Forum Discussion
Direct Query to Import
Hi,
I have a report that is built using Composite mode - Direct Query to AS (Azure). I realized that security settings on the cube are preventing users from seeing the report as intended. My IT department is recommending to switch my report to Import mode. After some research, it seems like there should be a table properties option to switch individual tables from Direct Query to Import mode, but that option is greyed out for me.
Any ideas what is preventing me from switching from Direct Query to Import?
Any other ideas how I can avoid rebuilding this whole report from scratch?
Hi Anonymous ,
I noticed that you are using DirectQuery to AS.
This indicates that when initiating a connection to a data source, the connection mode is Live Connection and then switches to Direct Query. It is currently not possible to convert a live connection to import mode. Consider voting for this idea.Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
5 Replies
You can find your solution in an old thread here :https://community.fabric.microsoft.com/t5/Desktop/Convert-storage-mode-from-direct-query-to-import-data-source-as/td-p/3025437
To change from Direct Query mode to Import mode in Power BI, follow these steps: Open your Power BI report in Edit mode. Click on the "File" menu and select "Options and settings" and then "Options" Click on "Data Load" in the left-hand menu.What is the version of your PBI ?
