Programmatically get data from datasource into an embedded report

[ash206]

Can I programatically access a data source (such as Amazon Athena), retrieve a CSV from it, then convert it to a dataset for an embedded report?

I was hoping to do this with PowerBI REST APIs but wasn't sure.

Constraint: I'd like to leverage the gateway connection between Athena and PowerBI without using PowerBI Desktop.

To my knowledge, if I have an embedded PowerBI report, I can dynamically bind to different datasets as long as the schemas match. I was hoping to do this all on a website without manually setting it up.

[Anonymous · Accepted solution]

HI @ash206,

I don't think you can fully automate it by programming codes. The query table and data transformation steps can not able to be configured or effect by the rest API.

If you mean to dynamic change the data source on the power bi service side by rest API, it is possible. You can parameterize your connection string with query parameters, then you can use the update parameter API to change and modify the data source mapping. 

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev 

Datasets - Update Parameters - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Notice: query table will cache the data structure into the query steps, do these data source should have the same data structure, or refresh will be failed and return an error for 'key not match'

Regards,

Xiaoxin Sheng