Different Result

[DuncanYeah]

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

[v-ssriganesh]

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.

[DuncanYeah]

Hi @v-ssriganesh,

I had review the information provided and everything look normal.And cannot found error in log.

Thank you.

[v-ssriganesh]

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.

[v-ssriganesh]

Hi @DuncanYeah,
I am following up to see if you had a chance to review my previous response and provide the requested information. This will enable us to assist you further.

Thank you.

[DuncanYeah]

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

[v-ssriganesh]

Hi @DuncanYeah,

We apologize for any inconvenience this may have caused and are pleased to hear that the issue has been resolved.

Your hard work and understanding are greatly appreciated.

Thank you.

[DuncanYeah]

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

[v-ssriganesh]

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.

[DuncanYeah]

Hi,

thx for your reply but by far still dont know the reason and the solution for this.

[v-ssriganesh]

Hello @DuncanYeah 
Thank you for your response.
Could you please share your PBIX file and specify the changes you are observing in the results?

[DuncanYeah]

Hi,

Thank you for your response. I cannot share the file to you as the data is confidential.

The chart that shows different result has not been changed for a while.

But the error occur in the last deployment.

[v-ssriganesh]

Hello @DuncanYeah 

I hope you are well.

Thank you for your response. We understand the data is confidential. However, you can share sample data without any confidential information. Please refer to the link below for instructions on providing the sample data.
https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/How-to-provide-sample-data-in-the-...

Additionally, could you inform us of the error encountered during the last deployment? If possible, please provide screenshots of the failed deployment. This will help us investigate the issue and offer a better solution. Also, could you share your expected output?

[Jai-Rathinavel]

@DuncanYeah Have you tried checking the report in a different browser ?. Also check for any page level or visual level filters applied. 

Thanks,

Jai

[v-ssriganesh]

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.