Visual correct on desktop, wrong on web

[Meeresblume]

Hello,

I have created a report with various key figures for a project. Each key figure is its own SQL script with the associated project number and all are linked to the main table via the project number.

If I open the report with the Power Bi Desktop, all ~10 key figures and project information are displayed correctly. If I publish the report, then all project information is displayed correctly, but from the key figures one knows the error "The data for this visualization was not found." on.

All metrics are created with the same visual, there is no difference. The query works, but the data is also not displayed in a table or in another visual. On the Power Bi desktop but already....

I published the report in another account, the data is also displayed there without any problems in the web view?!? What can be the reason?

[v-yanjiang-msft]

Hi @Meeresblume ,

Has your problem beed solved? If so, please kindly accept the helpful reply as solution, then we'll close the thread, other people who has the similar problem will benefit from here. Thank you!

Best regards,

Community Support Team_yanjiang

[v-yanjiang-msft · Accepted solution]

Hi @Meeresblume ,

One possible cause is that the data source cache is corrupted. You can easily fix this by clearing the data source cache in Power BI. In Power BI Desktop, go to Data Source Settings, select the data source that you are using, and click Clear Permissions. Then, refresh your report and republish it. 

Another possible cause is that the data source credentials are not updated or valid. You can check and update your credentials in the Power BI service. In the Power BI service, go to Settings, select Manage gateways, and then select Data sources. Find the data source that you are using, and click Edit credentials. Make sure that you enter the correct credentials and authentication method for your data source. Also check the gateway status and make sure that it is up and running. Then, refresh your report and see if the error is resolved.

A third possible cause is that there is a mismatch between the data types or formats of your key figures in Power BI Desktop and in the Power BI service. You can check and fix this by opening your report in Power BI Desktop, going to Edit Queries, selecting each key figure column, and making sure that the data type and format are consistent with your data source. Then, apply the changes, refresh your report, and republish it.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.