Push dataset and replace existing one connected to report - REST API

[jaryszek]

hi

i have report published and want to change entire dataset connected to using REST API.

Code for my Table imported in M:

let
    Source = Excel.Workbook(File.Contents("C:\Users\Jacek\Documents\SourceTables.xlsx"), null, true),
    Table1_Table = Source{[Item="Table1",Kind="Table"]}[Data]
in
    Table1_Table

1) Do i have to delete whole dataset and post new one? Or i can replace somehow existing one? 
2) What steps should look like and how to write json to post dataset for this one table? 

Please help,
Jacek

[jaryszek]

Hi Gao,

thank you!

according to this documentation:

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/update-datasources

you can update dataset. 

But question is how to do this? 

I could have this table pushed with new dataset also but i do not how to create json to make this working.

Best,
Jacek

[Anonymous]

Hi @jaryszek ,

Yes, but this has some limitations. Only paginated reports are supported to replace data sources of the same type.

I apologize for overlooking this, is your report a paginated report?

What are paginated reports in Power BI Premium? - Power BI

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[jaryszek]

o wow thank you. 

It is just a report. 
So no way to connect to existing published report and change json files inside it?

Best,
Jacek

[Anonymous]

Hi @jaryszek ,

Unfortunately, as far as I know there is no way.🙁

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous · Accepted solution]

Hi @jaryszek ,

1) Do i have to delete whole dataset and post new one? Or i can replace somehow existing one? 

I checked the REST API list and there is no API for replacing dataset. 

Datasets - REST API (Power BI Power BI REST APIs) | Microsoft Docs

You may consider replacing the data source and republishing it here.

2) What steps should look like and how to write json to post dataset for this one table? 

Not supported.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data