Forum Discussion
Creating measures for live connect model
I am creating a model in Power BI Premium service using 1 capacity with multiple workspaces. These workspaces will have datasets that have published DirectQuery chained datasets. End result is that the user will use Live Connect to the chained dataset. My question is how to handle measures and calculated columns. Is there a way to put all measures in a separate dataset that can be shared across "chained" datasets? For example:
Dataset1 contains Constituents and Revenue
Dataset2 contains Events
Dataset3 contains Memberships
Dataset4 (chained) contains Constituents/Revenue + Events from which the user will create Live Connection reports.
Dataset5 (chained) contains Constituents/Revenue + Memberships from which the user will create Live Connection reports.
Where/how do I publish measures that will be shared between Datasets 4 & 5?
Hi, Anonymous
I'm afraid it couldn't be achieved in Power BI for now. For your requirement , you can come up with a new idea and add your comments on Power BI Ideas forum to make this feature coming sooner.
Best Regards,
Community Support Team _ Eason
3 Replies
Anonymous , when try to add a second live connect dataset, in the new version you should get an option for the direct query. in that, you should be able to use those datasets together, but you might have to create measures in this new file
Yes, I understand that. Datasets 4 & 5 will be DirectQuery with multiple data sources (1 & 2 and 1 & 3). My question is how to share measures across datasets. Datasets 4 & 5 will have many of the same measures. Is there a way to store them separately so that I don't have to put them in both? I dislike duplicated code and try to avoid it if possible.
Hi, Anonymous
I'm afraid it couldn't be achieved in Power BI for now. For your requirement , you can come up with a new idea and add your comments on Power BI Ideas forum to make this feature coming sooner.
Best Regards,
Community Support Team _ Eason
