Change DirectQuery Power BI Dataset to SQL Server and all visuals adobt the new SQL Server Dataset

[BuistJF]

I have a large report that is currently linked to a direct query, published PBI dataset. I want to have the SQL logic that creates the published PBI dataset within the PBI report as a SQL Server import dataset.

I want all the visuals in the report to auto regonise this new dataset (all columns and data types will be the same as the orginal dataset) as the direct query will be deleted. Is there an easy way to do this rather than having to manually update each visual?

If it was a mater of switching between 2 sql server import queries that is easly managed in Power Query. Obviously when attched to a direct query, PBI dataset there is no advanced editor avaiable in transform data for obvious reasons.

[lbendlin]

Do it in two steps

1. Change the Direct Query source from dataset to SQL server table or view.  Make absolutely sure that the result is exactly the same, down to the spelling and punctuation.   Cannot emphasize this point enough

2. Change the storage mode from Direct Query to Import Mode.