Status:
Done
Changing data source to or from SQL to a file removes all data groups / bins from the model
Changing the data source in a Power BI Report from an Excel file (or CSV file) to a SQL server query causes any data groups / bins that have been set up to be removed from the model. This happens whe...
If you connect to SQL with Direct Query mode , then change the data source , the data you reference is definitely a problem because DQ's connection pattern is to send queries to the data source, not to store the data to PBI Desktop. Once your data source changes, there is no way to get the data from the SQL data source .
Best Regards,
Community Support Team _ Ailsa Tao