Source is Azure SQL server and destination is powerbi

Question

Source is Azure SQL server and destination is powerbi

Anandhswarupp 205

Source is Azure SQL server and destination is powerbi IMG_20240906_222049

Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator

2024-09-09T15:48:58.7366667+00:00

@Anandhswarupp Thank you for reaching out.

Could you please specify in a bit more detail what you are trying to achieve so we can provide you further assistance.

Regards,

Oury
Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator

2024-09-16T21:31:04.5366667+00:00

@Anandhswarupp Checking on the status of the issue above. You are trying to connect to an azure SQL dB with Power BI.

Were your database set up with public endpoint. If yes you will need to add client IP in the networking tab of your SQL server in the portal.

Is your connection policy set up as default.

1 answer

Your answer

Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator

2024-09-09T15:48:58.7366667+00:00

@Anandhswarupp Thank you for reaching out.

Could you please specify in a bit more detail what you are trying to achieve so we can provide you further assistance.

Regards,

Oury
Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator

2024-09-16T21:31:04.5366667+00:00

@Anandhswarupp Checking on the status of the issue above. You are trying to connect to an azure SQL dB with Power BI.

Were your database set up with public endpoint. If yes you will need to add client IP in the networking tab of your SQL server in the portal.

Is your connection policy set up as default.

Answer 1

Amira Bedhiafi 41,116 Volunteer Moderator

Try to connect to the Azure SQL Database in SSMS, then select the large table to check your desired fields. After executing an appropriate query to get data in SSMS, apply this query statement in Power BI Desktop.

Try to optimize your database and tables. https://alexandrebrisebois.wordpress.com/2013/11/30/steps-towards-optimized-windows-azure-sql-databa... https://alexandrebrisebois.wordpress.com/2014/01/26/indexes-are-crucial-on-windows-azure-sql-databas...

Share via

Source is Azure SQL server and destination is powerbi

1 answer

Your answer