- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
Subject | Author | Posted | |
---|---|---|---|
06-26-2024 01:59 PM | |||
Anonymous
| 11-24-2021 11:10 PM | ||
12-11-2023 05:34 AM | |||
08-01-2024 02:11 AM | |||
07-14-2023 06:09 AM |