Unable to Change power bi data set from live to composite model

[Anonymous]

Hello Community, 

I am having a data set in service that is connected to a AAS data base through Live connection and that using that data set i have created several reports as well.

Now, i am trying to change the data set connection to Direct Query as per below microsoft Documentation in Desktop. 

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-...

After changing to direct query and creating new columns to that data set, when i publish though desktop, report gets published with the below message

So after this, if i download the same report from service and open it in desktop, the model is still in Live connection and the changes are not Reflected. 

When i try to replicate the same scenario by creating a  new datas set with AAS as a direct query and publish everything works as Expected. 

So my Question is, Is it not possible to change the existing Live query data set to Composite or Direct Query? If so why the publish is saying successfull?

Thanks in advance.

[Anonymous]

Hi @Anonymous ,

Please check the similar case. The above provides a lot of solutions for encountering such problems, which may be helpful to you. Like Clear cache, change settings, etc.

Solved: publishing is complete, however we couldn't refres... - Microsoft Power BI Community

Best regards.
Community Support Team_ Caitlyn

[Anonymous]

@Anonymous  Thanks for the swift reply.

However, We already went through the idea and tried those solutions but in our case it was not working.

[jeroenterheerdt]

when you do this you are _extending_ the dataset, so publishing this would create a new dataset, which is as expected. If you want to add the calc table, you should open the original PBIX. The feature you mentioned extends / enriches existing datasets and publishes the result as a separate entity. What you are looking for is not part of this feature.

[Anonymous]

@jeroenterheerdt Thanks for the reply. However i am opening the original PBIX for adding the calculated table. 

But i do get that i cant change a original dataset that is in live to Composite without a new dataset. Is there any way to rewire all the reports that are part of the lineage of original file without having any impact in the Report ID since we already embedded all the reports to our Company Portal?

[jeroenterheerdt]

You can try to rewire using the APIs - that should not change the Report ID, but I am not sure it will work in all cases.