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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      not working with me :(

      after enable " direct query "

       from options restart still disabled ...!!!

       

       

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you!!! 2022 and still saving lives!!! 🤣

    • kim_m's avatar
      kim_m
      New Member
      3 years ago

      Amazing - thats for sharing, it was impossible to find in MS documentation