Forum Discussion

shalini-ms's avatar
shalini-ms
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

Can we create dataset(from WEB/API) using Power BI REST API

Greetings,   Can we create a dataset from a WEB/API data source using the Power BI rest APIs? The Data source API requires token authentication to get the data.   From the Power BI desktop, we a...
  • shalini-ms's avatar
    4 years ago

    Hi,

     

    Thank you team, I got the required information. 

     

    I hope this will help others:

     

    • We should not use Power BI rest APIs to create regular datasets, it is suitable for the Push datasets
    • Power BI rest API has a limitation of 75 columns for the push datasets
    • One should use TOM (Tabular Object Model) or XMLA to create a regular dataset to overcome the above-mentioned limitations
    • TOM/XMLA only works for Premium workspaces and only if the XMLA endpoint has write activities enabled for the capacity the workspace is assigned to.

     

    https://docs.microsoft.com/en-us/analysis-services/tom/tom-pbi-datasets?view=asallproducts-allversions#create-a-new-console-application

     

    Best Regards,

    Shalini