Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
This is an excellent feature that is very useful for us. But We are not able to change the existing power bi Datasets in Service to Composite model. We need to create a new dataset everytime? We have many reports that are embedded in our site and dont want any impact on the Report ID's
- jeroenterheerdt
this feature is built to allow you to extend / enrich existing datasets. That would turn them into a composite. Not sure why you would want an existing dataset into a composite if you are not changing / extending it. If you added extension / enrichment you will be creating a new dataset and can leverage an API to "rewire" your reports if you were so inclined. https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-datasources
Not sure if i explained it right. I have a existing dataset for which i would add a calculated table. after adding calculated table, when i publish the data set it is publishing as a new dataset and not overwriting the already available dataset even though the names are same. if this is expected behaviour, rewiring the reports will make the report id change?
Hi Anonymous, we work with PBI datasets on a daily basis, updating and expanding upon them: for instance by adding a calculated table to an existing PBI dataset. This way of working is also called the 'Golden Dataset' principle, and will not change IDs of dataset or linked reports.
If you are working in the original file (.pbix) of the dataset, and publish this accordingly, the expected behaviour is that the dataset in the PBI Service will be updated (you will also see a warning in PBI Desktop when publishing notifying you of this).If the above does not help, could you provide more information on the steps you are actually performing when extending upon an existing dataset?
