Skip to main content

    Power BI

    Needs Votes

    Create new dataset based on Azure SQL database using REST API

    Vote (4) Share
    Ruslan Zolotukhin's profile image

    Ruslan Zolotukhin on 16 Mar 2018 22:00:20

    For now it is not possible to create new dataset based on Azure SQL database using REST API. It is working for Azure Analysis Services - https://msdn.microsoft.com/en-us/library/mt203562.aspx. It will be helpful in automatic Power BI deployment.

    Comments (1)
    Ruslan Zolotukhin's profile image Profile Picture

    Joe Taylor on 05 Jul 2020 23:40:52

    RE: Create new dataset based on Azure SQL database using REST API

    100% agree. When it comes to creating DirectQuery data sources, I hope that the Power BI team will work towards feature parity between Power BI Desktop and the REST API. We would like to create review environments for every update to our analytical database, but it is not currently possible to automate this. This is a major barrier to adopting DevOps practices in our Power BI development work.