This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Is there a place in Power BI Service to see whether a connection is a Direct Query or Import? I want to be quickly able to determine the connection type.
I found 2 reports that I know first hand the connections type. I looked at the Lineage of the 2 Reports, one being a Direct Query and the other an Import using a SQL Query, and I don't see anything that points out the difference. Any help would be appreciated.
Hey @mcornfield ,
the only place I know that might contain the information you are looking for is the dataset API: Datasets - Get Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Docs
The result might contain a property called targetStoragemode
But to honest, i have no idea what to expect
a dataset in import mode returns: Abf
a dataset in directquery mode returns: PremiumFiles
Hopefully, this provides some new ideas.
Regards,
Tom
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 13 | |
| 11 | |
| 8 | |
| 8 | |
| 7 |
| User | Count |
|---|---|
| 38 | |
| 27 | |
| 25 | |
| 22 | |
| 22 |