Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I created a PBIX report file that I use on multiple data sets. To that end, I've created a separate file for the data model. This way, I can ETL data from different clients into a separate data model for each client and not impact the DAX in the reports PBIX file.
My gain in doing this is that I can consistently point the PBIX reports file at a different PBIX file for the data model and it all works (no DAX changes necessary).
I've found it to be very tedious to take totally different data sets and get them shaped into the correct data model each and every time.
Anyone got any tips or products for streamlining this process?
Solved! Go to Solution.
Dataflows come with Pro license and uses Power Query. You dont need a datawarehouse
Dataflows come with Pro license and uses Power Query. You dont need a datawarehouse
You can get a Power BI Pro per user license for $20 per month and create Data Flows that support computed entities (eg things like merging tables).
Currently, dataflows created with a Pro Premium User license can be accessed by Pro-only workspaces. Sweeeet.
Try using dataflows. Copy paste the code to each client account.
"I've found it to be very tedious to take totally different data sets and get them shaped into the correct data model each and every time. "
Welcome to the club, I guess? Unless you have good company wide data stewardship (and I have yet to see a real world example) that work - getting the data model right - will continue to occupy most of your time. Reporting is 95% data preparation and 5% presentation.
Ha, thanks! I probably need a standard data warehouse so I can connect and re-use the PBIX file with the reports.
I've gotten pretty comfortable with Power Query and would like to use something like that to ETL into a data warehouse.
I've also thought about getting a Power BI Premium User account and using Data Flows.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
14 | |
13 | |
12 | |
12 | |
12 |