Direct Query SQL Server Database

[MikeMCFRS]

Hi All,

I am currently working on project- Dashboard- and I used direct query to connect to a SQL databse server. The goal is to have a dashboard that updates/refreshes based on the data from the server.

I have a couple of questions as follows
a)what will happen to the main data source is If I use the query editor to clean up/modify the various tables to suit the needs of my project

b) I have read elsewhere that direct query can impact performance and calculation functions. Is this the case?? Do I use the import option instead and will that help with refreshing in powerbi service??

c) I have a total of 15 tables in the particular databse name that I am using for the project. All the tables have systemID and primary key. Will the system key be the best way to connect all the tables??

Your kind ideas are welcome

[Greg_Deckler · Accepted solution]

Couple thoughts,

a) Queries are read only, the source data will remain the source data regardless of modifications made in the query

b) So, with Direct Query you are making a call to the source whenever calculations are made and visuals are displayed. So, depending on numerous factors, yes there can be a performance impact. Import models can help address these as all of the data is then stored in the Power BI Service

c) Sounds like the way to go, but would need to fully understand your data model to be certain

[MikeMCFRS]

---

@Greg_Deckler wrote:

Couple thoughts,

a) Queries are read only, the source data will remain the source data regardless of modifications made in the query

b) So, with Direct Query you are making a call to the source whenever calculations are made and visuals are displayed. So, depending on numerous factors, yes there can be a performance impact. Import models can help address these as all of the data is then stored in the Power BI Service

c) Sounds like the way to go, but would need to fully understand your data model to be certain

---

Hello Greg, Many thanks for sharing your thoughts on this case. Is it possible for you to remote in to see my model??