Forum Discussion

kanth32's avatar
kanth32
Icon for Advocate I rankAdvocate I
9 years ago
Solved

How to change direct query to import query

Hi Team ,    I have connected to HANA DB and created one reporting using Direct query option . Now i want to change from Drirect query option to Import query option . I tried to change in edit quer...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi kanth32,

     

    If you're connected by Direct Query, you'll see the message "DirectQuery: Enabled (Click to Change)" in the status bar at the bottom right hand screen on Power BI Desktop:

     

     

    Click on the message, then you should be able to change Direct Query to Import Model.:smileyhappy:

     

     

    Regards

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

 

Can you see something like this in Query Editor, Change the Connection Settings to Import Mode,

kanth32's avatar
kanth32
Icon for Advocate I rankAdvocate I
9 years ago

Hi  Bhavesh , 

 

Thanks for your reply 

 

we are not able to get that option in edit query . 

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    9 years ago

    You can see this message when you select the Source option in your query applied steps.

    • kanth32's avatar
      kanth32
      Icon for Advocate I rankAdvocate I
      9 years ago

      Hello Bhavesh , 

       

      i can able see the import and direct query option .. in Edit query but there it was disabled please check my intial screen shot 

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi kanth32,

         

        If you're connected by Direct Query, you'll see the message "DirectQuery: Enabled (Click to Change)" in the status bar at the bottom right hand screen on Power BI Desktop:

         

         

        Click on the message, then you should be able to change Direct Query to Import Model.:smileyhappy:

         

         

        Regards