Latest Enterprise DNA Initiatives

Direct Query - Change or Delete Direct Query (to import)

I tested a Direct Query for my calendar table to a dataset published to the PowerBI Service.
I now want to go back to import.
I have not been able to find a solution.
I do not have this option in my view:

I think it may be a system/permission setting?

Hi @DMercier.

I think if the option is available you’ll see “DirectQuery: Enabled (Click to Change)” in the status bar at the bottom right of the screen in Power BI Desktop; from there you should be able to choose “Import”.

Here’s a link that may help (specific to SAP Hana, but …)



Thank you for the quick response. I do not have that option on my screen. I have submitted a ticket to IT. I assume it is in the setup.

Hi @DMercier, did the response provided by @Greg help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

Hi @Dmercier, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!