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.
TimeTue Nov 29 2016 11:33:23 GMT-0800 (Pacific Standard Time)
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