Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a report in the service which has a couple of pages with a few different visuals such as the standard gauges,tables, and matrixes that come with a power bi report. Most of the pages load fine and diplay the correct data, but one specific table will not load - and is using the same data source as the other visuals that are loading correctly.
I receive the error message below for the table. This is incredibly frustrating because the table that will not load - will load in desktop, will load in the service editor, but will not when using the publish to web link in PBI service.
I'd also like to add that I have added multiple filters to the data to narrow down what is displayed. With filters applied, the results should show about 20 vendors.
Hi @Anonymous,
Any RLS setting enabled on this report? If this is a case, I'd like to suggest you to take a look at limitations about publish to web feature:
Publish to web is supported for the vast majority of data sources and reports in the Power BI service, however, the following are not currently supported or available with Publish to web:
Regards,
Xiaoxin Sheng
Thanks for your response! No I'm not using RLS or any of the 1-9 mentioned.
I think a formula I'm using is slowing it down making it not load.
It's literally the only formula in the table. It's an if statement that's weighting different measures based on if they are tier 4 or not.
Example - if([tier]="Tier 4",
([measure 1]*.1+ [measure 2]*.3 + [measaure 3]*.25 +[measure 4]*.25+ [measure 5]*.25) *.5,
([measure 1]*.1+ [measure 2]*.3 + [measaure 3]*.25 +[measure 4]*.25+ [measure 5]*.25))
And it's when I add this measure to any table in the report that all the sudden that specific associated visualization cannot load.
HI @Anonymous,
I think this issue should due to your formula, it will bring your visual very heavy workload with loop calculation when visual load data.
For e.g.
Your visual will get additional calculation amount = row count * ( measure 1 calculation + measure 2 calculations +.... + measure 5 calculations)
BTW, if they contain rolling calculation, it will expand to current row + current row-1 +current row -2 +...+ first row.
I'd recommend you to take a look at following links about measure performance:
Optimizing DAX expressions involving multiple measures
Power BI Performance Tips and Techniques
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.