How to swap data sources in Power BI Used for swap import mode data source types with Power BI 00:00 Intro 00:46 Notes 02:24 Steps 03:17 Demo 06:11 Troubleshoot 08:11 Advanced Editor 09:43 Thank you
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!
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
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.
Hi Daniel, I made a part 2 of this video to demo Excel to SQL. Hope the Part 2 give you some ideas ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-8EHKyIGVb1I.html 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!
@@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"
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.
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.