cancel
Showing results for 
Search instead for 
Did you mean: 
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
Microsoft


@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
Microsoft


@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.

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

 

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Dev Camp Session 30

Ted's Dev Camp - January 26, 2023

This session will provide guidance and teach campers the skills required to build Power BI reports that support multiple languages.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.