Change the Data Source TYPE of the Power BI Dynamically using Power Query Parameters

I have written a blog article and explained how Power Query parameters can be used to change the data source in Power BI. Another useful scenario of it is actually to change even the data source itself. For example, you may have two data sources with exactly the same data structure (columns), but different data. One of them is Excel, and another is the SQL Server database table. In this video, I show you how you can switch between these without needing to change your code and publish again. All of that using Power Query parameters.
Find the links to study more in my blog article below:
*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD

[shivmantra]

Rezza, this video doesn't deserve 100+ likes. It deserves a million+ or more likes. Thank you for this video

[munidulam]

@RADACAD, Your way of teaching is excellent. This video is really useful to me. Infact, not only this video, all your videos are useful. I'm thankful to you!

[marvinalavi]

Thank you Reza, that saved me 20 days of time!

[seamushand]

Really useful and clear explanation. Thank you

[sianthuraisingam]

Thanks this is really helpful and will save a lot of manual rework to rebuild with different data source type

[linustorvalds]

Very useful, I did something similar to point to a local folder vs a Sharepoint, great tutorial.

[dareemmanuel]

Thanks for the tutorial. Where do I get the links you keep mentioning because I don't see them in the description like you stated. Thanks

[mladenradosevic]

Great stuff.
Any thoughts how to stop refreshing if datasource is missing?
Custom Error message or just do not refresh...

[vladimirmihaylov]

It is worth pointing out that parameter options are not available for Power BI reports deployed to Power BI Report Server. It will be good to know, how to achieve the same in such cases?

[shaibeezz]

Hi,

i am facing one issue in Power BI Desktop V Nov2021- I need to connect the two different types of files (xlsx and HTML) at the same from the same folder. both types are having the same structure (number of columns and header). The current type is xlsx is connected and now I have to add the HTML type in the same folder. for this, I have created a parameter? as data will continue in both files.

appreciate your help in advance.

[irfanpukhta]

Can I pass the datasource as a parameter in the URL of the published report?

[chaitubhogireddy]

This approach work for direct query ? im seeing this error

Failed to save modifications to the server. Error returned: 'DirectQuery partition has '2' datasource reference(s) in its expression which is not allowed. '.

[hlooole]

I tried to connect it with google drive but didn’t work for me, it was showing me error in displaying visuals

[DanielWeikert]

Question would be how to offer this feature to an end user. He/She is not able to click edit queries and there is no way to link a parameter from the report to the backend powerquery parameter or is there?
Highly appreciate your input here!

[mokshi]

Thanks @radacad
I have one qn
What if we had to add three or more data source what is the query for that?
Can u pls explain

[smartwork]

Hello Genius,

I never miss your any of the videos and you are absolutely amazing in this.

Well, i have one query if you could guide me here,

- Let's say i have load query from folder and i have multiple files available in that folder belongs to every month sales and let's say i have built one report and loaded in excel using power query.

- Now after deleting a few files from folder, how could i keep old file data in excel where i have loaded the query besides that file get removed from folder?

- as we know after refracing of query it would load fresh data only in model.

basically, i want to preserve old data also in my excel where i have load the query.

Thanking you in advance.

[hirdeshgupta]

Thanks, two questions
1. Can we just replace excel to DB query so it will point to SQL?
2. Can I do same for Merge query?

[unick_gul]

Can we use parameters for the data source of snowflake in power bi?

[arkaprovasaha]

Can we do the same for azure databricks in a similar way?

[AliHoolash]

Than you for this nice tutorial, Reza! I am facing a similar situation right now where I need to update the data source from a Power BI Report from Excel to SQL Server. What if I don't want to keep that Excel data source and work only with the SQL Server data source? Can I simply overwrite the M codes in "Fact Internet Sales" with those from "Fact Internet Sales (2) (and thus get away with the need to create a new Parameter)?
Would this approach still maintain the existing relationships among the tables?