SWAP DATA SOURCES EASILY using Parameters in Power BI // Beginners Guide to Power BI in 2022
Vložit
- čas přidán 28. 06. 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
bit.ly/3dJE2O7
👍 Become a Patreon to support the channel and get free perks!
/ solutionsabroad
🛍 Get exclusive templates built using best practices here
ko-fi.com/solutionsabroad/shop
solutionsabroad.co.uk/store
❤ Other ways to support
ko-fi.com/solutionsabroad
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
🌍 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 CZcams.
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
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 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.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence
It was an amazing lesson, straight to the point, and very educational. Thank you very much.
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 ?
Awesome! Thank you so much!
Thank you for clear explication!
Great Job!!!
Great Tutorial !
thank you!
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?
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?
Hi, would you recommend the Google DA course?
Hi, how can we change the source if the report is published in powerbi service which required schedule refresh. Could you suggest on this
check deployment pipelines
what if we publish the report in powerBI services then how we can change source there?
The solution should still work, as long as the source files are stored in an online source (eg SharePoint, OneDrive, etc)
hi... do you have training session
Hi Ivan, at the moment I don't do training sessions but perhaps I will organise something in the future!