Forum Discussion

StefanKainz's avatar
StefanKainz
Frequent Visitor
2 years ago

Push Dataset create table API

Hello,   I've created a push dataset with two tables via API as documented here: Push Datasets - Datasets PostDataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn   Now I'd like to ...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago
We cannot delete and recreate the whole dataset as explained

Power BI datasets semantic models are ephemeral. You MUST be able and ready to recreate them at any time. Do not rely on Power BI for any sort of long term storage.

 

Can you show the XMLA?

 

(If you think about the effort you have already put in all of this - would it have been quicker to start from scratch?)

StefanKainz's avatar
StefanKainz
Frequent Visitor
2 years ago
Do not rely on Power BI for any sort of long term storage.

We do not rely on Power BI for long term storage, no worries. We keep all the data and schema safe at another service. We cannot drop and recreate the dataset because we plan potentially dozens of reports and dashboards that would be gone/break when dropping the dataset semantic model.

 

If you think about the effort you have already put in all of this - would it have been quicker to start from scratch?

At the moment we start from scratch every day a few times. We are just evaluating the possibilities we have with push datasets. And we use to take all the necessary time to make sustainable architectural decisions.

 

Thanks again for all your explanations. For me it's clear now that it is not possible to add a table to an existing push dataset after it has been created and we have to find another solution to work with changing requirements.

 

BR Stefan