Forum Discussion
Best way to centralize data?? Dataflow??
Hi learning_dax ,
I will answer the last question first - no, there is no way to automatically have one dataflow triggered from another one (you might be able to do this yourself with Power Automate though).
I think the best centralization, if you want to share a basic setup and let others manipulate it is to use the DataMart. (Introduction to datamarts - Power BI | Microsoft Learn) This is not quite ready for full prime-time yet but should be soon. We are using it in production now already as well and it is working well and I think will work for what you explained above. Using a DataMart would let you stage all your data and let the users use it and manipulate it /add filters to it as needed.
Otherwise, you could do a Dataflow or two and just let folks know what they have to do a filter here or there (I wouldn't have multiple versions - unless you are doing so based on security).
Hi learning_dax ,
I will answer the last question first - no, there is no way to automatically have one dataflow triggered from another one (you might be able to do this yourself with Power Automate though).
I think the best centralization, if you want to share a basic setup and let others manipulate it is to use the DataMart. (Introduction to datamarts - Power BI | Microsoft Learn) This is not quite ready for full prime-time yet but should be soon. We are using it in production now already as well and it is working well and I think will work for what you explained above. Using a DataMart would let you stage all your data and let the users use it and manipulate it /add filters to it as needed.
Otherwise, you could do a Dataflow or two and just let folks know what they have to do a filter here or there (I wouldn't have multiple versions - unless you are doing so based on security).