CODEWITHSUNDEEP
powerbi
michael95677
michael95677

Reputation: 21

Power BI and Shared datasets how to allow users to create new measures and reports and publish

We are having difficulty finding a method of sharing a dataset and allowing users to use that dataset to create and publish their own reports. This would include ability to create new measures (Dax) and then publish themselves. Using the "service" live connection does not seem to allow that and if not using that there seems to be an issue of refreshing the data once that dataset is downloaded and modified with new columns/measures etc. 

Greatly appreciate any help on this. So far I have seen nothing that shows how to do any of this so I have to assume it may not be possible? Thank you. 

Upvotes: 0

Views: 694

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89331

Live Connect to a Power BI Dataset allows for local measures.

If you need more modeling changes when working with a remote Data Set, the DirectQuery for Power BI Datasets and AAS feature (currently in preview) enables you to mash-up remote Data Set tables, with local tables, and allows for adding calculated columns to remote tables.

But you should use this with some care, as the query processing is split between the local model and the remote model(s), which can cause performance issues.

Upvotes: 0

Related Questions