My client has been using this report for months on PowerBI.com. and today reported 3 visualization could not be loaded. these visualizations have been working for several months without fail.
the measures work with Power BI Desktop just will NOT render on PowerBI.com
All other reports with the same Enterprise Gateway are working.
1. delete and publish dataset
2. adjust dax formulas -- replace 'Divide' with '/'
3. fully qualify fields within measures "Table[Credit Limit]"
4. conducted a peer review who confirmed the measures no longer work on PowerBI.com
Couldn't load the data for this visual
Couldn't retrieve the data for this visual. Please try again later. Please try again later or contact support. If you contact support, please provide these details. Activity ID33401b52-8063-91ea-f4c5-1b0e3ce961f5 Request ID1f51c9d7-4a62-1053-eac3-85cf6e4db325 Correlation ID2772c86f-8a55-c7a8-472d-9e9154b72343 TimeTue Nov 29 2016 11:33:23 GMT-0800 (Pacific Standard Time) Version13.0.1700.740 Cluster URIhttps://df-msit-scus.analysis.windows.net
Direct Query: Azure Database
Measure displays the percentage of AR with Credit limit coverage % of Total = Sum(Table[ARofCL])/Sum(Table[Total_AR]) -- Divide AR with Credit limit by Total AR ARofCL = Table[ISManaged]*Table[Total_AR] -- Calculate amount of AR with Credit limit ISManaged = IF(Table[CreditLimit]>0,1,0) -- flag records with Credit Limit > 0