Forum Discussion
shalini-ms
Microsoft Employee
4 years agoCan 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...
- 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.
Best Regards,
Shalini
nqzhhzmn
Advocate II
4 years agoHow to use the Rest API to create a push dataset?