Forum Discussion
Push dataset and replace existing one connected to report - REST API
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
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 TeamIf 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
5 Replies
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 TeamIf 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
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,
JacekHi 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 TeamIf 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
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
