Advanced section not display

[Anonymous]

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 doesn't show. Why?

Any help is greatly appreciated!

Max

[Anonymous · Accepted solution]

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

Thank you all for replying.

Max

[v-binbinyu-msft]

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]

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

[vanessafvg]

can you share a screenshot of what you are looking at and can you give an example of what you are expecting to see.