Solved: Direct Query to Import

Anonymous · ‎10-26-2023

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?

Anonymous · ‎10-30-2023

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 Team

If 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

View solution in original post

AmiraBedh · ‎10-26-2023

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-d...

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.

https://zebrabi.com/guide/how-to-change-direct-query-mode-to-import-mode-in-power-bi/#:~:text=To%20c...

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Anonymous · ‎10-26-2023

I don't see a "Data Connectivity Mode" option.

AmiraBedh · ‎10-27-2023

What is the version of your PBI ?

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Anonymous · ‎10-27-2023

Version: 2.122.746.0 64-bit (October 2023)

Anonymous · ‎10-30-2023

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 Team

If 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