Forum Discussion

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
7 years ago

Best Practices for Common Data Models

Following up on a previous question, since I cannot do any additional modeling when connecting to a Power BI Dataset, I'm curious as to the best way to be able to work off of a common data model.   ...
Tips and Tricks
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi AlexisOlson,

 

Based on my understanding, you have multiple Power BI reprots connecting to similar data source, what you want to achieve is that after publishing reports to Power BI service, they share the same dataset hosted on service in order to avoid dataset redundancy. However, publishing a report to service will automatically saving a dataset on service, this is by design. Unless you connect to the existing dataset stored on Power BI service which can be shared by multiple reports. Live connecting to Power BI dataset still allows you to generate measures. Apart from this, I'm afraid there is no other workaround.

 

Best regards,

Yuliana Gu