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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • shalini-ms's avatar
    shalini-ms
    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