Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
tunlinaung
New Member

Desktop PowerBI connection with SQL Database on AWS

Dear All, 

 

Good days. 

We have SQL Database Server on AWS and we are connected from Desktop PowerBI by using Gateway. 

I am wondering, whether there will be any impact to Application Database since 1 SQL Database accessing from 2 Applications. 

1 is Read & Write access from Application and another 1 is from PowerBI. 

Your suggestion will be much helpful. 

 

Best Regards, 

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @tunlinaung ,

In my opinion, depending on your specific connection method, Power BI gets SQL data, both by import and by direct connection. When you use import, the data is loaded into Power BI Desktop once and when users access the report, they don't access the SQL database, so no requests are sent to the SQL database and there is no impact on the SQL database. When you use Direct Query, on the other hand, every time a user opens a report, a query request is sent to the database, which can have an impact on the SQL database if there is a large amount of data and a large number of users accessing it.

Refer:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @tunlinaung ,

In my opinion, depending on your specific connection method, Power BI gets SQL data, both by import and by direct connection. When you use import, the data is loaded into Power BI Desktop once and when users access the report, they don't access the SQL database, so no requests are sent to the SQL database and there is no impact on the SQL database. When you use Direct Query, on the other hand, every time a user opens a report, a query request is sent to the database, which can have an impact on the SQL database if there is a large amount of data and a large number of users accessing it.

Refer:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

Hi Lucien, 
Thank you so much for sharing. 

Since we are accessing data by "Import" Connection, we will no big issue based on your comments. 

It's very helpful information. 

 

Best Regards

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.