Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
francescbarraga
New Member

Doubt about Power BI Rest API -gateway

Hello!

 

I need some help using Power BI REST API  without Gateway. Let me explain the situation:
We want to create refreshable datasets with the PowerBI REST API using CSV data from the web (our company webserver) as datasources.
We can create a similar datasource in PowerBI manually without a gateway.
The API endpoint for creating a new datasource requires a gateway.
We want to avoid creating a gateway because it is not required for CSV datasources.

The question is,  how to create a datasource without a gateway using the PowerBI REST API as a service principal?

 

Thanks for your support

1 ACCEPTED SOLUTION

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://docs.microsoft.com/en-us/analysis-services/tom/tom-pbi-datasets?view=asallproducts-allversio...


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.

 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

5 REPLIES 5
bcdobbs
Super User
Super User

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?



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

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.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

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.

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://docs.microsoft.com/en-us/analysis-services/tom/tom-pbi-datasets?view=asallproducts-allversio...


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.

 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.