Switching data source and storage mode from import to direct query

[TomSinAA]

I have a report that uses a DSN to connect to a SQL Managed Instance and storage mode is set to Import.   I add a new source that uses direct query to a SQL Managed Instance that retrieves the same dataset.  I want to switch all visuals in the report to use the new direct query source.  Is there a way to easily switch the data source for all visuals in all report tabs without having the manually do it for each visual?

[Anonymous]

Hi @TomSinAA ,

Please try to change datasource in Power BI Desktop Data source settings.

For more details, you can read related document:How to Change Data Sources for Existing Power BI Reports - Iteration Insights

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.

[TomSinAA]

The data source is the same data source.  I am trying to change the storage mode from Import to Direct Query.  The existing table is set to storage but there is no option to change it direct query.  I pulled in the same dataset using direct query.  But if I change the name of the new Data to the original name and rename to orginal Data, the visuals still use the orignal Data.  

[Anonymous · Accepted solution]

Hi @TomSinAA ,

So far, if you get data from a data source by Import connection type, you could not change to other two connection types.

Please delete tables in Power BI Desktop that using import storage mode, then connect to the same data source with direct query and use the fields to visualize.

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. 

[marcelsmaglhaes]

Hey @TomSinAA ,

 Take a look in this post: Solved: Chnage storage mode to Direct Query from Import - Microsoft Fabric Community

[TomSinAA]

Storage Mode Direct Query is not listed as an option for the orginal dataset.