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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago
    What do you do if that message does not appear?