SWAP DATA SOURCES EASILY using Parameters in Power BI // Beginners Guide to Power BI in 2022

In this video were going to go through how you can use parameters in Power BI to dynamically swap your data sources.

-

🚩 Get Demo Files here

👍 Become a Patreon to support the channel and get free perks!

🛍 Get exclusive templates built using best practices here

❤ Other ways to support

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards

📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[burcucumcokguzelsin]

This is the exact thing I was looking for. You explained super clear. Thank you ! 🙏

[Trunks_]

It was an amazing lesson, straight to the point, and very educational. Thank you very much.

[Mahesh]

instead of doing it in parameter, can we do the same in slicer, so that the end users can easily switch between diff data sources ?

[tashaagrawala]

Is it possible for an end user to switch the data source using Power Automate? I want an end user to be able to click a button, have it prompt them to upload a file to SharePoint, and then automatically update the data source with the file they just uploaded. Is this possible?

[ushakiranmai]

Hi, how can we change the source if the report is published in powerbi service which required schedule refresh. Could you suggest on this

[taz]

Hi, would you recommend the Google DA course?

[rahulkumarbhagat]

what if we publish the report in powerBI services then how we can change source there?

[doriginal]

What if I want to use the Test and Prod data. I don't want it to overwrite the information that I have. Is this possible?

[JohnOCU]

Hi.
What if your dataset is a Power BI dataset?

Is it possible to parameterise the connection to different Power BI datasets. I have come to understand that best practice is to have separate Power BI datasets from the Power BI reports. This has all made sense to me until I have recently tried to implement Deployment pipelines. I can paramterise my conncetions within my model PBIX file, and then use the pipelines to change these connections from Dev, Test and Production.
However, for my report pipeline I cannot see how I can switch my reports to point from the dev model to the test model, and then the production model as the report is passed through the pipeline.

Have I missed something obvious?