Forum Discussion

bhavana_dfz's avatar
bhavana_dfz
Frequent Visitor
1 year ago
Solved

Push Datsets using Power BI REST API

I want to use rest api to create a dataset definition in using REST API ( REF : Push Datasets - Datasets PostDataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn). But the datasets i cr...
General Comment
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi bhavana_dfz ,

    For migration scenarios requiring Azure SQL connectivity and refresh support, use Power BI Desktop to define the dataset, then automate model updates via XMLA/TOM/Tabular Editor, and control refreshes via the Power BI REST API.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly.

    Thank you.

     

     

bhavana_dfz's avatar
bhavana_dfz
Frequent Visitor
1 year ago

Hi v-venuppu,

Thank you for the detailed explanation.

I understand now that Push Datasets are not suitable for scenarios requiring incremental refresh or scheduled updates, and that they lack support for external data source bindings like Azure SQL.

Just to clarify my original intent:
I was exploring the Push Dataset API as a way to create a refreshable the data source definition in Power BI during a report migration from another BI tools. My goal was to streamline the migration by programmatically creating and updating datasets.

Given this, is there a recommended approach or toolset (such as XMLA, Tabular Editor, or other APIs) for programmatically creating and updating datasets that are connected to an external source like Azure SQL—while still supporting refresh and incremental loading?

Appreciate your guidance, and thanks again for your support.

Best regards,