Forum Discussion

myal's avatar
myal
Regular Visitor
8 years ago
Solved

Problems on creating a new dataset with Power BI's REST API

Hello everyone!   I have set up Power BI pro subscription and a SQL database on Azure. My goal is to create a dataset with DirectQuery from this SQL Database through the Power BI's REST API and emb...
  • eligr's avatar
    eligr
    8 years ago

    Hi.

    The API you're trying to use creates a datasets that points to Analysis Services.

    Your datasource is SQL (Azure).

    We don't have support for creating such datasets from the API.

    You'll have to move your data to Analysis Services, use the "Push data" API or create the model in PowerBI desktop.

     

    link to the API doc:

    https://msdn.microsoft.com/en-us/library/mt203562.aspx

     

    Eli.

eligr's avatar
eligr
Power BI Team
7 years ago

Hi.

Creating a DQ datasets is not supported through the REST APIs, HDInsight or other.

To create such dataset, you should use Power BI Desktop.

 

Eli.

alfdagos's avatar
alfdagos
Frequent Visitor
7 years ago

Thanks a lot eligr!

 

Suppose once I've created the dataset with PowerBI Desktop, I want to duplicate and modify it to point to other tables of the same database or same HDInsight instance (naturally with the same schema..). Can you explain me the correct steps to do with the Rest API if it's possible?

 

Thank you very much for the fast replay!

 

Best regards,

    Alfredo.