Forum Discussion
Doubt about Power BI Rest API -gateway
Ok. No I don't believe the rest api can do that.
You'd need to look at the XLMA end point and interfacing with the tabular object model in C#.
https://powerbidevcamp.powerappsportals.com/sessions/session04/Also worth looking at tabular editor 3 if you're just trying to add a table
to an existing dataset in the service. You can create a table and paste the M code straight into it's partition.
Hi,
I'm assuming you're looking at this end point...
https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/create-datasource
It is specifically talking about a datasource in a gateway.
What is the end result you want to achieve? Wondering if you're really after a power bi dataflow to make the data available with the service?
Hello Ben,
We want to avoid the use of a gateway... is it possible using PowerBI REST API?
Afraid I'm not 100% clear on what you're attempting to do.
If you have an existing dataset you can configure it to automatically refresh within the service or use
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset
to refresh the dataset or specific tables within it. That definently doesn't need a gateway.
Thanks!
As far as I know, this endpoint is used to refresh a dataset that needs to have an underlying datasource for refreshing.
The problem is not that we cannot create datasets that can be refreshed from a datasource.
The problem is that we cannot create the underlying datasource with the PowerBI REST API in the first place.
Can we import Power Query M code with the REST API? With the code, we can describe a dataset and its datasource.
