Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi!
I am having some issues with data showing in visuals on the published version of my report.
In desktop version it is working fine and when publishing it is working the first time I open the report, however, after some time it stops showing data in my visualizations.
My PBI report is created using data from Excel files placed on a SharePoint location.
Published version example:
Desktop example:
I have tried different workspaces (including my personal one) with same results.
Refreshing the semantic model does not solve it.
The data sources are valid and the published version looks to have full access to the Excel files etc.
I really hope someone can help solve this frustrating issue!
Thank you in advance!
Solved! Go to Solution.
Hello @KPaaske ,
I suggest you download the published report and check it, sometimes power BI changes sme things or things happens when published.
so download the published report and investigate it.
Proud to be a Super User! | |
@KPaaske ,
try downloading it and rechecking it in power bi desktop to see what's preventing data from showing.
Proud to be a Super User! | |
Hello @KPaaske ,
I suggest you download the published report and check it, sometimes power BI changes sme things or things happens when published.
so download the published report and investigate it.
Proud to be a Super User! | |
Hi. I am facing exact same issues when I have downloaded the published version and opening in desktop even after refreshing all data sources.
When checking the tables I can see new refreshed data in my tables, so it is not the data sources having no data..
Hello @KPaaske ,
did you check if there's any filter that is preventing it to show, maybe a filter that is done in service.
try reseting filters on report by this green icon
Proud to be a Super User! | |
It did not solve it. After clicking that it seems like nothing really happened. When hovering over that button it shows this information:
Could that be the issue that it is reverting to some kind of default view?
Thank you for your support so far!
@KPaaske ,
try downloading it and rechecking it in power bi desktop to see what's preventing data from showing.
Proud to be a Super User! | |
Hi! So based on your comments about filters, I found the issue and corrected it.
Turns out for some "not-obvious-to-me" reason, the published version was converting a boolean filter from TRUE/FALSE into 0/-1 and that messed up my visuals...
So after aligning these two I am now seeing the exact same in each version.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.