Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
smpa01
Super User
Super User

Loading defaults to DQ

Is there a reson why all the table load defaults to DQ instead of import?

 

I am not even gettting the option to choose between DQ and Import for Storgae mode. How do I get past this.

 

Thank you in advance.

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
1 ACCEPTED SOLUTION

Thanks for the reply from@SaiTejaTalasila and@lbendlin, please allow me to provide another insight:
HI,@smpa01 

Regarding the issue you raised, my solution is as follows:

1.The storage type can be changed, but as SaiTejaTalasila explains, there is a limit to the conversion between storage modes: you can change the direct query table to import mode, but you can't change the import mode to direct query.

Here is a screenshot of the official document:

vlinyulumsft_0-1719803158354.png

2.If you've already imported your data into PBIX, you can try to modify it in the following places:

Find the corresponding semantic model you need to modify, and click on the following location:

vlinyulumsft_1-1719803183677.png

Modify the position of the following figure:

 

vlinyulumsft_2-1719803196206.png

3.If you want to change the storage mode in Desktop:

First of all, you can change it when you import the data:

vlinyulumsft_3-1719803209732.pngvlinyulumsft_4-1719803215101.png

Secondly, if you have imported data, you can also find a place to modify the storage mode in the table relationship:

vlinyulumsft_5-1719803227616.pngvlinyulumsft_6-1719803232497.png

4.The following documents are what we hope will help you.

Use storage mode in Power BI Desktop - Power BI | Microsoft Learn 

 

If you have any other questions, please feel free to contact us.

 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

3 REPLIES 3
SaiTejaTalasila
Solution Sage
Solution Sage

Hi @smpa01,

 

As per my knowledge, you can change direct query tables to import mode.And you can't change import mode to direct query(on a single click).

 

Thanks,

Sai Teja 

Thanks for the reply from@SaiTejaTalasila and@lbendlin, please allow me to provide another insight:
HI,@smpa01 

Regarding the issue you raised, my solution is as follows:

1.The storage type can be changed, but as SaiTejaTalasila explains, there is a limit to the conversion between storage modes: you can change the direct query table to import mode, but you can't change the import mode to direct query.

Here is a screenshot of the official document:

vlinyulumsft_0-1719803158354.png

2.If you've already imported your data into PBIX, you can try to modify it in the following places:

Find the corresponding semantic model you need to modify, and click on the following location:

vlinyulumsft_1-1719803183677.png

Modify the position of the following figure:

 

vlinyulumsft_2-1719803196206.png

3.If you want to change the storage mode in Desktop:

First of all, you can change it when you import the data:

vlinyulumsft_3-1719803209732.pngvlinyulumsft_4-1719803215101.png

Secondly, if you have imported data, you can also find a place to modify the storage mode in the table relationship:

vlinyulumsft_5-1719803227616.pngvlinyulumsft_6-1719803232497.png

4.The following documents are what we hope will help you.

Use storage mode in Power BI Desktop - Power BI | Microsoft Learn 

 

If you have any other questions, please feel free to contact us.

 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

lbendlin
Super User
Super User

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.