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 

 

Make sure that the connection mode of the 3 tables is the same? Is it possible that the tables that can be loaded are imported by you and the other two tables are connected by Direct Query?

 

When using DirectQuery with an Azure SQL Database and a private IP address, an on-premises gateway is required.

 

Refer to the following documentation to check if you have violated DirectQuery's precautions.

Use DirectQuery in Power BI Desktop - Power BI | Microsoft Docs

Azure SQL Database with DirectQuery - Power BI | Microsoft Docs

 

Best Regards,

Community Support Team _Charlotte

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

 

 

linch's avatar
linch
Microsoft Employee
4 years ago

From the setting page, I don't need a gateway.

Gateway connection

You don't need a gateway for this dataset, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect.