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.
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.
"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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.