Troubles with my measures

[EduardOrellana]

I cannot visualize my reports when I publish my Report, in power bi Desktop is working very well the all commands and measures and calculations are fine.

The problem is when I want to see my report in my any workspace.

This is the error.

Activity ID: 596c19ed-a6d0-4194-9274-fbc82e9c1624
Request ID: 26bb651d-94a6-427a-9419-2ac1eedbf72e
Correlation ID: 5347fa8f-c448-957e-b848-45e1f9d8fb07
Time: Tue Apr 16 2024 12:28:29 GMT-0600 (Central Standard Time)
Service version: 13.0.23072.58
Client version: 2404.2.18827-train
Cluster URI: https://wabi-north-europe-c-primary-redirect.analysis.windows.net/


And I don't understand why?, since My Desktop App is not presenting me any problem.

Someone knows?? What I could do to fix it?

[dobregon]

@EduardOrellana 

I have the same issue in my company. We have worked with the BIs in the service on monday at 7:00 UTC and at 8:00 UTC everything fails, and we start seeing these errors in many visuals. 

Syntax errors, not available capacity, etc.  There reports have not been changed for months so, it is not due to a change and without no reasons some of the reprots (the biggets ones with more calculations) starting to fail, but in local still working.

[v-zhouwen-msft]

Hi @collinq ,thanks for the quick reply.

Hi @EduardOrellana ,

Regarding your question, is the data stored locally? May I ask what is your connection mode? If it is Direct Query or Live Connection mode, you need to install a data gateway.In case of Import mode, the gateway is also required when refreshing the dataset

Install an on-premises data gateway | Microsoft Learn

I've searched for relevant cases and I hope this will help you.

1.The problem is the date type.

Solved: Service: "Couldn't load the data for this visual",... - Microsoft Fabric Community

2.SQL query completed with a semicolon

Solved: Couldn't load the data for this visual - Microsoft Fabric Community

[collinq]

Hi @EduardOrellana ,

Normally this is due to a change in the data or a column or something that simply can't be read in the service.

This article here explains how to troubleshoot this issue futher: Troubleshooting tile errors - Power BI | Microsoft Learn

[EduardOrellana]

Thaks a lot...

but the same problem

It doesn't make sense that in my Power BI Desktop I can see my measures and inside my workspace I cannot.

Really I'm loosing my mind.

[collinq]

Hey @EduardOrellana ,

The reasoning is that the Service and the Desktop process things differently in the background so every now and then something that works in Desktop won't work in the Service (and vice-versa I suppose).