Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have a graph that I've set up in PowerBI desktop which displays values correctly as they should be. However, once I publish the data and then view it in PowerBI web, the values are completely different.
I've ensured there are no filters affecting the data and all the other graphs that use the same data export and display correctly, so I'm not sure why this graph in particular shows different on web to what shows on Desktop.
I've tried copying the table to a new tab so it's on its own, but have the same problem. Any help as to why this might occur would be greatly appreciated.
PowerBI desktop graph:
Same graph in PowerBI web:
Thanks in advance.
Hi, @Kym_EVO
Outdated versions of gateway and PowerBI Desktop can cause a similar situation.
The repport showed difference data between power bi pro than the version in power bi desktop
Regard,
Ethan
Thanks @Ethan96 , I tried some of the suggestions in that link, including removing the boolean data types from my filters but unfortunately that didn't resolve the issue.
Hi,
If after publishing the report on the Server, you click on the link, that appears on the publishing page, it was happen to me once.
I found the Filter that was in my Filter Pane (for some reason).
Would you possible check your filter pane on the Server side and also 'Filter on Visual' in your visual :
Hi @MahyarTF , the only filters are those that I set in the desktop app that show the data for this year up to today:
Desktop:
Web:
oh, it is strange.
Not sure what the reason is.
maybe try another workspace to publish it (if not), and try it in your workspace before publish it in App
Thanks @MahyarTF , tried publishing to my workspace but same result unfortunately.
Agree, it's very strange. I've never seen the report differ from app to web like this. Thanks for trying to help.
Are you using Dataset for development?
I asked because sometimes the refreshing time is different between the Publishing and desktop version.
Is it possible, that you filter your data in Power Query and then publish it ? and see if the problem is remaining
Thanks @MahyarTF, I tried filtering the data in Power Query to only include the data for this year which didn't change the graph in desktop (as you would expect), but now the graph on web is different. It's correct up until week 8, then the data reverts to being incorrect (now I'm even more confused!):
Not sure, what the reason is it, Strange.
the last solution (not the best solution), is testing on another computer and run it the PBIX file on the desktop and then publishing it on the web, as you mentioned it is worked on the web, not expect some restrictions or getaway on your server side.
Appreciate your Kudos for my posts
@Kym_EVO , FIrst try there.
Clear browser cache -> Refresh and check again
Republish- > Clear browser cache -> Refresh and check again
Hi @amitchandak , thanks for the suggestion - I've tried refreshing cache as well as using multiple browsers on multiple PCs to ensure it's not a caching issue. All showed the same graph as above on web.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |