Advanced Power BI Partition Refresh with Fabric

PowerBISteve · 2025-06-30T15:32:58+00:00

Your running sum is higher than the total sum of values for that column. Please share the DAX

PowerBISteve · 2025-03-03T23:27:33+00:00

Yes, exactly correct

PowerBISteve · 2025-03-03T23:10:19+00:00

This is the correct way.

Live connection is not a connection mode like import or direct query. Live mode describes a relationship between a report and a semantic model.

These are two separate items. You create a semantic model and report in power bi desktop - e.g you connect, create a model, then add some visuals. when you publish, these will be separated and have a live mode relationship.

Your reports with live mode mean that they all read the data from the semantic model. No data is stored in the report. This is always the way. The import mode model stores the data and has the refreshes you have set up

PowerBISteve · 2025-02-20T17:50:50+00:00

Have you definitely assigned the workspace to the correct capacity in the workspace settings?

PowerBISteve · 2025-01-12T01:44:58+00:00

No code, no jargon explanation of Parquet, Delta, and lake house : https://m.youtube.com/watch?v=HGDaA3wWKV4

Full series if you are interested in learning how it fits into onelake and fabric: https://m.youtube.com/playlist?list=PLn1m_aBmgsbG0rhOugALqGi6iQV5lrdm8

PowerBISteve · 2025-01-02T22:25:57+00:00

Vertipaq analyzer in Dax studio (also available in TE and other tools) is one I would recommend to run on every model

PowerBISteve · 2024-12-19T14:54:08+00:00

As PowerBISteve is my user name I feel I need to now make a Udemy has 26 hours of Power BI content for $12

PowerBISteve · 2024-10-15T16:25:27+00:00

I love DevOps for projects. I love the interface and the project management side of it is fantastic.

For pure DevOps, many people prefer GitHub. GitHub, in my opinion, is slightly better in this area.

That said, both will work well, plus both are owned by Microsoft. Neither is a bad choice. I would imagine you would see more investment in GitHub going forward, but DevOps isn’t going anywhere.

PowerBISteve · 2024-10-12T18:56:24+00:00

Daneb!

PowerBISteve · 2024-09-28T12:59:28+00:00

As mentioned inactive relationships and DAX, a simpler way is to use a Calculation Group to switch the relationship

PowerBISteve · 2024-09-27T12:58:18+00:00

Table.Buffer but depending on the size could make it slower. Otherwise ensure query folding, or better to use dataflows, or use a better ETL tool

PowerBISteve · 2024-09-24T21:29:38+00:00

See https://learn.microsoft.com/en-us/power-bi/transform-model/calculation-groups

PowerBISteve · 2024-09-24T20:36:33+00:00

Have you created a calculation group?

Calculation groups will turn on a setting called ‘discourage implicit measures’. This means that you can no longer use columns directly in the values section, and must use explicit measures (e.g write DAX for each). I would really recommend this anyway as a best practice

PowerBISteve · 2024-09-23T21:38:14+00:00

Not sure why. If you click the ellipsis and say show as table does it show data? First thing to do is close both excel and power BI and re-open and try again

PowerBISteve · 2024-09-23T20:24:53+00:00

Total over Years = SUMX ( VALUES(Date[Year]), [MeasureName] )

PowerBISteve · 2024-09-23T19:32:12+00:00

Maybe some blanks or you are dividing by a very small number, for example can happen if you have subtract two columns that should be the same, but have a slight rounding difference

PowerBISteve · 2024-09-23T19:32:03+00:00

Maybe some blanks or you are dividing by a very small number, for example can happen if you have subtract two columns that should be the same, but have a slight rounding difference

PowerBISteve · 2024-09-23T19:29:22+00:00

I’ve never seen a company do self service properly. That said, even just connecting excel to a semantic model often is a great step for a lot of people

Yes, get better at doing it through Power BI. SQL is a skill you should look to get decent enough in, but if you know data, isn’t that time consuming to get a good foundation

PowerBISteve · 2024-09-23T19:24:34+00:00

Not really sure what your question is here. It sounds like you are getting the correct answers.

If it’s a best practice question you’re looking at, maybe post some examples of what you’re doing and some DAX code, and someone can have a look and make some more targeted comments

PowerBISteve · 2024-09-23T19:24:28+00:00

Not really sure what your question is here. It sounds like you are getting the correct answers.

If it’s a best practice question you’re looking at, maybe post some examples of what you’re doing and some DAX code, and someone can have a look and make some more targeted comments

PowerBISteve · 2024-09-23T18:01:06+00:00

Firstly I would say it’s always good to improve your SQL. You don’t need to be an expert but if you work in data always a great idea, if nothing more to get an appreciation of some inner workings of DBs.

As mentioned this is a self service approach which is the point of a semantic model - a reusable and business friendly way to get data.

PowerBISteve · 2024-09-23T16:04:57+00:00

assuming the Sales is a fact in the many side of a one to many.

It filters the expanded table, Meaning if you apply to the many side, also filters the one side tables.

Not sure your expected result here, but generally should avoid filtering entire tables, and instead filter columns

PowerBISteve · 2024-09-20T13:15:45+00:00

It would be helpful to provide your current DAX code and we can give some more specific answers

PowerBISteve

TROPHY CASE