Was it done with Import or DirectQuery?

[Anonymous]

When I publish my reports...

• if its in Import:  the dataset will live in app.powerbi (as it is a file in OneDrive).
• if its in DirectQuery:  the dataset will live in the source, so I might have some connection delay since it hits the source every time…

This was built by someone else; how can I check in this Dataset if its either Import or Directquery??

[Anonymous · Accepted solution]

Hi, @Anonymous 

I am glad to help you.   

According to your description, you want to know how to check if it is import or DirectQuery? 

If I understand you correctly, then you can refer to my solution.  

The first thing you can try is to download the semantic model from Power BI Service and open the .pbix file in Power BI Desktop, then look at the Storage mode to determine if it is import or DirectQuery: 

It is worth noting that when using DirectQuery to connect to a SQL Server database, it may prompt you to enter credentials to connect to SQL Server: 

You can also make a simple determination of whether it is import or Direct Query by using the gateway automatically selected by Gateway and Cloud Connections on the settings page.

Or check Data Source credentials after taking over this semantic model: 

If it has edit credentials, it is import, otherwise it is DirectQuery. 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.