Forum Discussion
How to change data source from EXCEL to SQL Server?
Hello All, Currently i have loaded all the files from my local disk to powerbi and those are all EXCEL sheets. then i have imported those excel sheets to SQL SERVER. Now i would like to chan...
I used the method advised here to change data source from Excel to SQL Server.
However, the challange I'm facing is changing the storage mode of the Excel Query that I changed to direct query as it still retained import mode.