cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
paris Regular Visitor
Regular Visitor

Edit Queries : Query setting

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Edit Queries : Query setting

Hi @paris ,

 

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

 

model.PNGGIFEncoder (7).gif

 

Regards,

Frank 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
9 REPLIES 9
Super User
Super User

Re: Edit Queries : Query setting

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

 

image.pngimage.png



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





paris Regular Visitor
Regular Visitor

Re: Edit Queries : Query setting

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

Super User
Super User

Re: Edit Queries : Query setting

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



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





paris Regular Visitor
Regular Visitor

Re: Edit Queries : Query setting

Hi Pattem,

 

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

 

All the best,

Paris

Super User
Super User

Re: Edit Queries : Query setting

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



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





Community Support Team
Community Support Team

Re: Edit Queries : Query setting

Hi @paris ,

 

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

 

model.PNGGIFEncoder (7).gif

 

Regards,

Frank 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
paris Regular Visitor
Regular Visitor

Re: Edit Queries : Query setting

HI Frank,

 

Thank you very much!

 

All the best,

Paris

paris Regular Visitor
Regular Visitor

Re: Edit Queries : Query setting

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 Regular Visitor
Regular Visitor

Storage mode

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