Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello Community,
We created a customer facing product using Power BI embedded. We created a tool to automate the uploading of our Power BI reports using the Power BI RESTful API. Prior to uploading a report update, we delete the existing report (if exists) then upload the update as shown below..
String reportId = GetReportID(report.reportName, report.groupId, client);
if (reportId != null)
{
client.Reports.DeleteReportInGroup(report.groupId,reportId.ToString());
}
We have seen that the data sets from previous versions of the report stay behind and they are auto-refreshing these causes our Azure SQL Server DTU’s to be constantly in use. We have about 20 reports and we are constantly uploading updates, therefore the number of datasets being left behind are increasing. You can see our datasets being duplicated every time we upload a new report.
My question is (and it may have an obvious answer, If so, apologize in advance) , should we manually delete the dataset first, then delete the report every time we update a report using the RESTful API?
If so, is something like the below code something we need to add prior to the client.Reports.DeleteReportInGroup(..) method??
var dsId = GetDatasetID(report.reportName, report.groupId, client);
client.Datasets.DeleteDatasetById(dsId.ToString());
Thank you all in advance.
Emilio
Solved! Go to Solution.
Hi @EChemali,
Based on research, current rest api contains refresh dataset function, but it seems like only suitable configured(setting gateway and other refresh options) datasets.(it similar as manually refresh)
For deatsets which manually create by rest api and push to power bi service, you can only remove original table rows and add new rows to achieve refresh option. Otherwise I think it will create duplicate datasets which you mentioned.
Notice: current rest api not has api to update existed tables, it also not contains function to update/replace original rows.
BTW, for operation rest api and power bi embedded, you can post to developer forum to get further support.
Regards,
Xiaoxin Sheng
Hi @EChemali,
Based on research, current rest api contains refresh dataset function, but it seems like only suitable configured(setting gateway and other refresh options) datasets.(it similar as manually refresh)
For deatsets which manually create by rest api and push to power bi service, you can only remove original table rows and add new rows to achieve refresh option. Otherwise I think it will create duplicate datasets which you mentioned.
Notice: current rest api not has api to update existed tables, it also not contains function to update/replace original rows.
BTW, for operation rest api and power bi embedded, you can post to developer forum to get further support.
Regards,
Xiaoxin Sheng
Thank you Xiaoxin for your help
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
53 | |
23 | |
22 | |
18 | |
17 |
User | Count |
---|---|
37 | |
18 | |
18 | |
17 | |
17 |