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

I updated Power BI Desktop to version "September 2022" and this issue is resolved. Thank you all for replying. Max

Advanced section not display | Microsoft Fabric Community

vanessafvg
Community Champion
3 years ago
can you share a screenshot of what you are looking at and can you give an example of what you are expecting to see.
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
  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
Anonymous
Not applicable
3 years ago
I updated Power BI Desktop to version "September 2022" and this issue is resolved.

Thank you all for replying.

Max