Reply
lferdinand
Frequent Visitor

Create a Dataset programatically

My design requires that I create 1 or more tenant-specific datasets to service a single dashboard whose data comes from a common elasticsearch cluster.  Data is stored in tenant-specific indices in es. Given that, I assume that I could create a dataset per dashboard per tenant. I don't see how I would go about doing that in the examples in docs.powerbi.apiary.io.

 

Are my assumptions accurate?

 

Basically, I'm trying to programmatically perform what an author would do when clicking on Get Data button in the lower right corner of app.powerbi.com....

 

Does the process work like this....

 

1. Create a Gateway (tenant-specific)

2. Associate the Gateway with a dataset?

3. Associate or create a new dashboard from a template to the Gateway....

 

Thanks

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft Employee
Microsoft Employee


@lferdinand wrote:

My design requires that I create 1 or more tenant-specific datasets to service a single dashboard whose data comes from a common elasticsearch cluster.  Data is stored in tenant-specific indices in es. Given that, I assume that I could create a dataset per dashboard per tenant. I don't see how I would go about doing that in the examples in docs.powerbi.apiary.io.

 

Are my assumptions accurate?

 

Basically, I'm trying to programmatically perform what an author would do when clicking on Get Data button in the lower right corner of app.powerbi.com....

 

Does the process work like this....

 

1. Create a Gateway (tenant-specific)

2. Associate the Gateway with a dataset?

3. Associate or create a new dashboard from a template to the Gateway....

 

Thanks


@lferdinand

You can create datasets via the REST API Create Dataset. The datasets created via the API have to be fed with REST API Add Rows. See Push data into a Power BI dataset. You don't set up gateway in this scenario.

View solution in original post

2 REPLIES 2
Eric_Zhang
Microsoft Employee
Microsoft Employee


@lferdinand wrote:

My design requires that I create 1 or more tenant-specific datasets to service a single dashboard whose data comes from a common elasticsearch cluster.  Data is stored in tenant-specific indices in es. Given that, I assume that I could create a dataset per dashboard per tenant. I don't see how I would go about doing that in the examples in docs.powerbi.apiary.io.

 

Are my assumptions accurate?

 

Basically, I'm trying to programmatically perform what an author would do when clicking on Get Data button in the lower right corner of app.powerbi.com....

 

Does the process work like this....

 

1. Create a Gateway (tenant-specific)

2. Associate the Gateway with a dataset?

3. Associate or create a new dashboard from a template to the Gateway....

 

Thanks


@lferdinand

You can create datasets via the REST API Create Dataset. The datasets created via the API have to be fed with REST API Add Rows. See Push data into a Power BI dataset. You don't set up gateway in this scenario.

avatar user
Anonymous
Not applicable

@Eric_Zhang -
Hi, not sure if your still around since the original post was a long time ago.
The links you posted just go to the API Documentation home page.
I was wondering if you have updated/better links.
Also is this still the best option. Create a Pushdataset and push the data.

 

Jeff

 

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)