Forum Discussion
Failed to load data
Hi, v-zhangli, thanks for your help! I have figure out the gap of good data table and bad table. The data source of the bad table must be set as "Import" instead of "Direct Query". However, I have some other Azure SQL database data source in the same report work with "Direct Query". All the datasource are AAD credentials. Maybe it's due to different setting in sql db?
Hi, Zhangli
Thanks a lot for your reply!
I created a blank dashboard to test the data sources connectivities. It turns out that the three tables I mentioned in the original question are all loaded failed. The credential of the Azure SQL db is AAD based, when I refresh the dataset, it will not report a refresh failure, but the table will not loaded. Here is the details:
Activity ID: f20bbd9c-c9a6-460e-9172-613180361401
Request ID: 0a0f97bd-6745-0bff-d5f1-cea5e15ec582
Correlation ID: ac785fe8-1f03-56a5-e3c0-18ed7e779479
Time: Mon Aug 29 2022 16:04:03 GMT+0800 (GMT+08:00)
Service version: 13.0.18988.36
Client version: 2208.5.13018-train
Cluster URI: https://df-msit-scus-redirect.analysis.windows.net/
Here is the refresh history of the dataset:
Hi, linch
In your case, the refresh can be done, but the table cannot be loaded. Considering that data access is restricted, what are the permissions of your account that accesses the data source? Does the report itself use RLS?
Best Regards
Hi, v-zhangli, thanks for your help! I have figure out the gap of good data table and bad table. The data source of the bad table must be set as "Import" instead of "Direct Query". However, I have some other Azure SQL database data source in the same report work with "Direct Query". All the datasource are AAD credentials. Maybe it's due to different setting in sql db?