Solved: Create a Dataset programatically

lferdinand · ‎10-23-2017

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

Eric_Zhang · ‎10-24-2017

@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

Eric_Zhang · ‎10-24-2017

@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 · ‎04-08-2022

@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