Power BI Datamarts vs Dataflows vs Shared Datasets // What's the difference?

In this video were going to cover what datamarts are and how it differs with other solutions that already exist like Dataflows or Shared Datasets.
-
🚩 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

[@Chaithrika6363]

Thank you Fernan for making it simple!

[@kudratilla]

great video, exact information what I was looking for. And extra thanks for telling the pros&cons openly (especially the cons)

[@techdelasabana]

Thanks for sharing Fernan. Question: in the last section of the video you showed the server URL. Do you know if it is possible to create records or update records using an external tool such as Power Automate or Power Apps? I heard from a colleague it is not possible.

[@kel78v2]

Can i just ask whether it’s really an issue if one can’t create dax columns but it still allows you to add custom columns directly to the tables?

[@atulsingh5484]

need to calculate the rental days
So for example
If I have a rent start date of 15th April I want to be able to select a Month filter to get the days on rent
So if I select April I’ll get 15 days (end April - 15th April)
If I select May I should get 31 days (End May - Start May)
If the rental end date is June 15th then if I select June I should get 15 days
If I select July I’ll get 0 because the item is off rent
I tried to create a date table and a measure to calculate but no luck

[@emach4392]

Could you create a demo step by step on creating data mart and using data mart?

[@davidlopez-fe2lb]

Around the 3min mark you mentioned that a user of a shared dataset can't create measures, this isn't true. They can create new measures using a shared dataset but they'll live in the report and not impact the model itself. We use this practice a lot, we create "standardized measures" on our shared datasets that all our developers can use but they still have the ability to create new measures if they need.