Forum Discussion

linch's avatar
linch
Microsoft Employee
4 years ago
Solved

Failed to load data

I load 3 tables from the same Azure SQL database. one of the table can be loaded successfully but the other 2 tables can't be loaded. The report works well in desktop app, the issue only reported by ...
Need Help
  • linch's avatar
    linch
    4 years ago

    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?

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

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

linch's avatar
linch
Microsoft Employee
4 years ago

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?