cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate I
Advocate I

Thank you Power BI team for the easy data model change

This is just to say THANK YOU to the MS Power BI team!

 

I am in a middle of a project at this moment where I am redoing one existing Desktop pbix file that is used as a dataset for several report files. The current solution is taking the data from txt files stored on sharepoint. I am exchanging those files now with direct tables connection in the DWH. There are 4 fact tables and 2 dimension tables that need to be changed.

On top there are >50 measures, followed by 40 report pages, etc., so I really don't want to touch those. Ideally, I would only change the source tables.

 

This is why I am writing this thank you letter - because it's so easy to change the source without breaking the entire solution! For instance, I connected the DWH table, made sure that the fields have the same names and then simply deleted the previous table and renamed the DWH connected table to the name of the previous table - et voila - all measueres work, no #source error messages or whatever - this is great! Thank you!

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi @romgut,

I think the template and query parameters feature will also suitable for your stairs, normally it works to keep the raw report design and switch between different data sources. (notice, you need to double-check on the data source to confirm they are work with the same structures or they will return an error for the cached query steps not match with the records from the changed data source structures)

Deep Dive into Query Parameters and Power BI Templates 

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev  

Also, thanks for sharing the usage scenario of power bi features.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support
Community Support

Hi @romgut,

I think the template and query parameters feature will also suitable for your stairs, normally it works to keep the raw report design and switch between different data sources. (notice, you need to double-check on the data source to confirm they are work with the same structures or they will return an error for the cached query steps not match with the records from the changed data source structures)

Deep Dive into Query Parameters and Power BI Templates 

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev  

Also, thanks for sharing the usage scenario of power bi features.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors