Power BI: How to Swap Data Sources

[@chuminfeng5205]

Great video! thanks for the troubleshooting part and details of the M code

[@SrinivasReddy-ss8xl]

very detailed session, helpful for beginners

[@mmiftaulhaque]

This was very helpful to me. Thank you for your time and efforts.

[@weiweiwang012]

Hi Matthew, Nice video! It's really the topic that I want to know more! Do you think that you can touch on swap data sources between SharePoint folder (stored excel files) and Power BI dataflow source? Thanks in advance!

[@muraliprasath99]

Thank you so much. This is very useful for me to change my Data Source.

[@dantepraxedis]

Awesome! Clearly explained!

[@bandanim9417]

Really useful, thank you

[@tlee7028]

Thank you so much for sharing.

[@KumarGaurav-x6i]

Can you please create and upload video for how to swap excel data source with Big Query table ?

[@DanielWeikert]

Hi Matthew, thanks a lot for your video. Could you show it when switching from excel to oracle? When I tried it with SQL I noticed that all the calculated columns (created with DAX) threw errors. I had to delete them. Have you experienced issues there? Thanks! bR

[@IndigoVFX]

Daniel Weikert Hi, without seeing your DAX or M the only thing that jumps to mind is to check your case sensitivity. Oracle stores table and view columns in upper case unless they’ve been specifically wrapped in “marks”, in which case the exact casing is used. That is: “myData” and myData are not the same. The first will be seen as myData and the second as MYDATA. Hope this helps.

[@fishleaf]

Hi Daniel, I made a part 2 of this video to demo Excel to SQL. Hope the Part 2 give you some ideas kzbin.info/www/bejne/bnarfKx_fLuVZ6s If you are still facing issues, you can submit a ticket from admin.powerplatform.microsoft.com/newsupportticket/powerbipro and to deep dive with a support agent!

[@DanielWeikert]

@@fishleaf What I noticed was that when I replace the data source from excel to sql then my calculated colums (in DAX) throw errors that the column "already exists"

[@DanielWeikert]

@@IndigoVFX Thanks for your idea. See my answer above. The issue seems to be that Power BI does not accept the pre created DAX columns.

[@yiminglu5971]

yeah it really helps. Thanks!

[@gerfer6261]

Very nifty 👍👍

[@pl4195]

Hi Matthew, I need your help. I have one question about Power BI. I make one sales report everyweek with one excel as data source. How can I save all these weekly report in the same power BI report so I could look back previous report by clicking the filter.

[@summalai]

Hi Matthew, When I tried to change my data source from SQL to Excel, always pop-up a error said" "This query contains transformations that can't be used for DirectQuery" . Any idea? really appreciated.

[@monitoringincar4237]

how to swap data source from file xls to folder?

[@1972Sammy]

What if the news data source has more columns?

[@stephenclarke7351]

nice hack