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