Existing VISUALIZATIONS fail to load on PowerBi.com

[Jshaw3515]

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

[Jshaw3515]

Visual on powerBI.com

Hi Power BI Support, any guidance on how to work around this issue with Power BI.com ?

% of Total Visual fails to render the percentage value,  see details above

[v-haibl-msft]

@Jshaw3515

The measure formulas should be right since the visuals display correctly in Power BI Desktop. I tried to get data from Azure Database with DirectQuery and create a measure with similar formula as yours, but cannot repro the issue after publish to Power BI Service.

BTW, if you are using Direct Query to Azure Database, no gateway should be needed as below.

I suggest you to create support ticket at http://support.powerbi.com (see bottom of page) since it may be tenant or account specific.

Best Regards,

Herbert

[Jshaw3515]

Herbert thanks for checking - I have opened a ticket and will post the resolution

[jryno]

I'm facing an issue with Power BI Desktop where my .pbix file won't open due to a data model corruption error. The error message mentions that Power BI failed to verify the database structure, specifically: A column named 'warr no' has issues – This column may have a broken hierarchy, duplicate values, or an incorrect data type. The 'T_divss' table has errors – This table seems to be corrupted, possibly due to bad relationships or a structural problem. The entire data model is affected – Power BI is unable to load the database, likely because of these inconsistencies. 🔹 What I Have Tried So Far: ✔ Trying to open the file in Safe Mode. ✔ Renaming and extracting the PBIX file, then deleting the DataModel folder to remove the corrupt database. 🔹 Still Not Fixed! 😞 Has anyone else experienced this? How can I fix this without losing all my work? Any help would be greatly appreciated! 🙏