Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Advanced section not display

I am using Power BI Desktop (May 2022) and trying to change a table from DirectQuery to Import. However, in Model view -> table Properties pane, I only see General  section, the Advanced section does...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    I updated Power BI Desktop to version "September 2022" and this issue is resolved.

     

    Thank you all for replying.

     

    Max

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

If you're connected by Direct Query, you'll see the message "Storage Mode: Direct Query(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.

 

 

The second way is:  go to Model view-->Advanced and change the storage mode from DirectQuery to Import

 

if you cannot change, please update your Power BI Desktop version.

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for your reply. The second way is just what I need but the "Advancde" is not showing thoug I have  updated to version "May 2022".

 

Do you know what version do I need to support this "Advanced" feature?

 

Max