Forum Discussion
How to call PostDatasetInGroup() to create datasets populated by an OData service?
I will also point out this page in the API documentation. Are these limitations that apply to PostDatasetInGroup()?
https://docs.microsoft.com/en-us/power-bi/developer/api-dataset-properties
Microsoft EmployeeHi Anonymous,
I'm afraid these documents can't be applied in your scenario. The datasets created through APIs are push dataset. The workaround is getting data from the OData service and pushing them into the dataset.
Best Regards,
Dale
Dale,
Unfortunately, that's what I suspected.
Is there an Suggestion Box where we can vote on this issue? If not I might create one.
Thanks,
Richard
- v-jiascu-msft
Hi Richard,
I found a similar idea here. A workaround come to me is as follows. The step 2 in your first post can't be done for now.
1. Create a pbix file in the Desktop.
2. Post the pbix file to an App workspace using imports/postimportingroup.
3. Update the data source using datasets/updatedatasourcesingroup.
4. Trigger a refresh of the dataset using datasets/refreshdatasetingroup.
You may give it a try.
Best Regards,
Dale