Forum Discussion
Change DirectQuery Power BI Dataset to SQL Server and all visuals adobt the new SQL Server Dataset
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 impo...
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.