Edit Queries : Query setting

[paris]

Hi All,

I want to change Data Connectivity mode from Import to DirectQuery under Query function. 

Query setting → Applied Steps → Source → SQL Server database → Data Connectivity mode 

Then I change from Import to DirectQuery →　OK → Close & Apply →　Save

However, next time I check, it remains unchanged. Can you help me?

All the best,

Paris

[PattemManohar]

@paris Try changing the "Storage Mode" under "Model". Select the Table to see the properties.

[paris]

Hi 

I was able to show storage mode but can not change from Import to direct. Do you know why?

All the best,

Paris

[paris]

Hi Pattem

Thank you for your message.

I only have three icons (vizualizations / table / relationship ) on the left but not the one you mentioned.

How can I display?

All the best,

Paris

[PattemManohar]

@paris I think you need to update your Power BI Desktop with the new version. 

[paris]

Hi Pattem,

I updated to new version but could not find the tab. Uhm. 

All the best,

Paris

[v-frfei-msft · Accepted solution]

Hi @paris ,

Please enable the option as the picture below. Then you should find the tab.

Regards,

Frank 

[paris]

HI All,

It was originally imported but want to change to Direct Query. 

I selected Options → Preview Features → Model view.

When I check Storage mode, I have three selections Import, Direct Query and Dual.

I can only chose Import , other twos are in dark grey colour. 

What can I do?

All the best,

Paris

[paris]

HI Frank,

Thank you very much!

All the best,

Paris

[PattemManohar]

@paris Make sure you have enabled preview features unders options and settings.