Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Existing visuals
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.
RCA Steps:
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
Details error:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.