Dataset changes on every refresh, loses data. Datasource unchanged. PowerBI online service issue.

[rhaddad87]

I have a report that has been running completely fine since March of this year until as of late.  I have tried multiple times to try and fix it in a number of ways but I believe this to be an issue with the storage layer of the PowerBI online service.

My issue is the PowerBI report on the Desktop Service works completely fine, even when I refresh data.  The report looks exactly as it should, the dataset matches the Dataverse tables.  When I upload that report to the PowerBI online service, it still looks fine.  Now, when I refresh the dataset on that report, a lot of values will go missing all of a sudden and I lose half the data on the report.  I confirmed that the Dataverse tables sources haven't changed from report upload to refresh and I still get the same issue. I've been pulling my hair out trying to figure out what is wrong but ultimately, I have concluded that this is a Microsoft PowerBI Online service issue, and not an issue with my report or datasources.  Requesting help from a Microsoft rep or someone who has had a similar issue and perhaps fixed it.

Right now, I am "going around" this issue by just manually refreshing the data in PowerBI Desktop and manually pushing the report & dataset to the Production workspace with no data refresh.

any help is appreciated. 

[rhaddad87]

I just want to update anybody reading this.  Turns out, it was a 3rd party visual (HierarchySlicer) that was affecting my report.  I deleted the visual and removed the visual from the visual pane and the report and the issue is resolved.  If youre having similar issues, remove any 3rd party visuals before you start pulling your hair out.

[foodd · Accepted solution]

Please open a new Issue, or if this is more urgent:

Urgent Issues

First and foremost, the community is a "best effort" kind of support forum. There are no true guarantees or service level agreements (SLA's) regarding when you might get an answer. You may not get an answer. Don't get me wrong, the community is an incredibly robust and amazing resource but if you are having an urgent issue that needs to be addressed immediately, you need to get actual Microsoft support involved. To do this, open a support ticket here:

Power BI - https://support.powerbi.com
PowerAutomate - https://flow.microsoft.com/support
Power Apps - https://support.powerapps.com

[rhaddad87]

Oh thank you very much for this information!  I submitted my ticket yesterday.