Upload Datasets only with Power BI Embedded analytics ‘Import’ API
Posted on Friday, 7 June 2019
Power BI APIs allows you to upload content into a workspace using the ‘Import’ API, which uploads a PBIX file. As we know, a PBIX contains both a report and a dataset, and they are uploaded together.
There are cases where this coupling is not optimal, and you might prefer to handle each object separately for automation scenarios. So in order to manage datasets separately from reports, we added ‘skipReport’ parameter to the ‘Import’ API that only uploads the dataset into the specified workspace.
This new API can be useful in few cases:
- A BI developer has made a change in the model only, and he doesn’t want to override the connected report in the PBIX. He can use the API to update only the dataset, without changing any of the reports bound to this dataset.
- Update a bulk of datasets with the same schema, but different data (for different customers), without worrying if a report might be damaged from the update.
- If you are an ISV and you have a new customer, you want to clone the golden analytics package for that customer, as recommended here. You can now upload only the relevant dataset, and then connect all the reports bounded to it through ‘Clone’ and ‘rebind’ APIs.