Forum Discussion
Was it done with Import or DirectQuery?
- Anonymous2 years ago
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.
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.