Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
I am getting below error in Power BI service.
"Couldn't load the data for this visual. The query referenced calculated table xxxx which does not hold any data evaluation of one of the row caused an error".
The report works fine when I use Power BI Desktop. This report has a schedule for data refreshing. The Data Connectivy mode is Import.
Details:
Activity ID: 9a7d4d09-c122-464a-a2d3-77e27080d46c
Request ID: 3e212cf8-794f-496f-9cda-8f8fb5aa56d6
Correlation ID: 0580b664-3750-7235-5ccb-0c04b2053a76
Time: Tue Dec 21 2021 13:47:07 GMT-0600 (Central Standard Time)
Service version: 13.0.17333.37
Client version: 2112.2.09063-train
Cluster URI: https://wabi-us-north-central-h-primary-redirect.analysis.windows.net/
Any help would be greatly appreciated.
Thanks in advance!
--- Miguel
Solved! Go to Solution.
@Anonymous
@Anonymous
Hi, @Anonymous
According to the error message, it is considered that the data from the relevant data source can't be obtained.
Can you provide more details about the visual? Screenshot or a simple sample file.
What's your calculation table like? Does it contain multiple data sources? Have you set up the gateway on service?
I also found one similar icm issue: 275902988 about 'Couldn't load data for this visual'. The fix of the issue has been checked in and waits for resuming the deployments after holidays.
You can also wait a few days and check it out, but since there are many reasons for this problem, it don't rule out that it will not help your problem.
Best Regards
Janey Guo