Power BI - Change Data Source from Excel to SQL Server - M & Power Query trick

[@RamayanapuDurgaPrasad]

Really Very help full and clear communications. Subscribing your channel Now

[@Data.Analytics.Central]

Thanks a lot for the appreciation! 🙏

[@arungupta8444]

What if the Source File is used for the Merge + Append + Group transformations with other files . but now the source file got Updated with Lots of Data and it is difficult to update the file and we need to replace the source file alltogether, with new file with same name, without affecting the previous output. Can it be done with "Parameters" Setting or something else. Please Advise.

[@eddychelene2124]

Hi, have you found a solution?

[@PallaviChauhan91]

I am new to the SQL. In every tutorial I see that only CSV files are being used with SQL. I have used EXCEL file with multiple subsheets as my data source, it's in import query mode but I want to make it direct query so tha power apps forms can auto refresh. Your trick is very neat but is there any way to make it work with excel files? Thanks.

[@Data.Analytics.Central]

Hi Pallavi. The procedure should be similar for Excel file. What is your challenge?

[@PallaviChauhan91]

@@Data.Analytics.Central While importing Excel files "Import Data" wizard is giving this error "The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine. (System.Data)" So the only way left is "import flat file" , CSV?

[@Data.Analytics.Central]

@@PallaviChauhan91 unless you solve the reasons for that error, you are left with CSV

[@PallaviChauhan91]

@@Data.Analytics.Central Yes, I am trying with CSV because solving this error is way beyond my current understanding. Thanks for creating this detailed tutorial.

[@eliasnassif4314]

Verry nice thanks

[@Data.Analytics.Central]

Thanks a lot for the appreciation! 🙏