Forum Discussion
Different Result
Dear All,
I just encounter a problem that the power bi desktop and power bi report server display are different reuslt.
I had tried to clear the cache and restart power bi report server. However, it didnt work.
Anyone encounter the same error and what is the solution.
Thank you.
Best Reguards,
Duncan
HI v-ssriganesh ,
After try all the methods provided we still cannot figure out the reason.
We eventally filter out the data as user request and the problem dont exist anymore.
At last thank you for your reply and follow up.Regards,
Duncan
14 Replies
Hi DuncanYeah
Thanks for posting your query in community forum.Here are several steps and considerations, which may help resolve your problem:
- Check that your Power BI Desktop and Power BI Report Server versions align.
- After publishing, check that the refreshed data source. Check if scheduled refreshes are working as expected or refresh manually.
- Check for both Power BI Desktop and Power BI Report Server to establish a connection to the same source with the same credentials.
- Check if there are other filters or slicers in Power BI Desktop and Report Server.
- Clean the cache of the report server and even restart the server.
- Verify that the data model hasn't changed since the last publish. Check calculations and measures.
- if using Row-Level Security, check if it is working as expected in both Desktop and Report Server.
- In Power BI Desktop, use the Performance Analyzer to see how queries are being executed.
- Look for any error messages or logs on the Report Server.
If nothing else works, try making a minor modification in Power BI Desktop and re-publish the report.
If this help then please Accept it as solution & don't forget to drop a "Kudos", so other members can able to find this more rapidly.
Hope this will work.
Thanks.DuncanYeah Have you tried checking the report in a different browser ?. Also check for any page level or visual level filters applied.
Thanks,
Jai
Thx for all reply.
The dashboard did not applied any row level security.The page level filters are checked both are the same.
I had re-published a new dashboard with a changed vsiual name but the result still different between desktop and report server.The report server version and desktop version are aligned both are Jan 2024.
And there are no error reported from the server and log.
I do have not try to open in different brower and I will try to do that later.
Best regard,
Duncan
Hi DuncanYeah
Thank you for your patience. From the steps outlined above, please let us know if anything was helpful to you, so that we can convert it into a formal answer. If so, we would appreciate it if you could Accept it as a solution and drop a 'Kudos' so other members can find it more easily.
Thank you.Hi,
thx for your reply but by far still dont know the reason and the solution for this.
Hi DuncanYeah
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi v-ssriganesh,
I had review the information provided and everything look normal.And cannot found error in log.
Thank you.
Hello DuncanYeah,
Hope you are doing well.
From our previous discussions, I understand that you are still facing issues with the environment. To investigate and provide a solution, we need the error message or a screenshot. This will allow us to review the error and update you accordingly.
Thank you, Have a great day.
