Power BI One Minute Monday - Switch between multiple data sources with Parameter
No sound just video!
Switch between multiple data sources with Parameter:
1) Open Power Query Editor
2) Create a New Parameter under Manage Parameters
3) Choose a name for the Parameter
4) Set Type as Text
5) Set Current Value (put in the Link to your current data source)
6) Save the Parameter
7) Change the data source path unter source in your tables
8) Close and apply
9) Open Transform data tab in the ribbon
10) Choose your new Parameter to switch between the sources
Good to know: the parameter appears in the service as well!
Have Fun!
