Hey all, my team is wanting me to migrate some really large datasets in order to start utilizing a brand new data warehouse that a consulting firm has built for us.
We were using an older “data warehouse” which actually wasn’t really a data warehouse, and where the data team was building out these views in order for us to pull into our datasets to build reports off of.
So now we have this new data warehouse and I’m trying to figure out my next steps going forward.
I have the older report combined with the dataset which I’m comparing to a new pbix file which has pulled in some of the data warehouse entities along with their relationships. Obviously, I can’t just copy paste the visuals from the old report and paste it in the new one because the table structures are much different. I’m very new to this type of work so I’m not exactly sure how I should be approaching this. Any advice or recommended readings/videos would be appreciated.
Dataflows is something I’m fairly new at, but managed to make one for a previous report and migrated everything to pull off of that dataflow instead of a single dataset. I was blow away by the benefits this could have for our team. However, with this new data warehouse, I’m trying to think of a way to utilize both the warehouse and dataflows. Again, any recommendations would be greatly appreciated.
Hi @Everett - Don’t think there is an automated way possible for your scenario considering Table structure is different.
If you are using same visuals in the new report, then you can consider copying visuals from the old one and point to the tables/columns from the new Data warehouse otherwise only solution I can think of is to create new dashboard using Data warehouse.
Due to inactivity, a response on this post has been tagged as “Solution”.
If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.
Migrating to a new data warehouse can be a complex process, especially when dealing with different table structures. To start, it’s essential to thoroughly understand the new data model. This involves reviewing the schema and table structures of the new data warehouse to grasp how entities are related and how they map to your previous data model. Document these relationships and structures for future reference.
Once you have a clear understanding, the next step is to map the old dataset fields to the new data warehouse fields. Create a mapping document to identify which tables, fields, and relationships need to be recreated or adjusted in the new environment.
Rebuilding dataflows is another crucial step. Given your previous success with dataflows, adapt or recreate them to work with the new data warehouse. Develop dataflows that pull data from the new warehouse and transform it as needed for your reports.
When it comes to reports, you’ll need to start from scratch in your new PBIX file, aligning it with the new data warehouse schema. This may involve redesigning visuals and reports to fit the updated data model, including creating or adjusting measures as necessary.