Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 d...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

AmiraBedh's avatar
AmiraBedh
Super User
2 years ago

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.
 
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    2 years ago

    What is the version of your PBI ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Version: 2.122.746.0 64-bit (October 2023)

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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