topic Re: Programatically interact with Power BI in Developer

Programatically interact with Power BI

jaryszek — Mon, 09 May 2022 10:37:09 GMT

Hi Guys,

i want to:

1. Create tables and relationships automatically using API from java

2. Prepare some reports in Power BI (it has to be manually set up ? )

3. Generate PDFs with reports from external code

It is possible? Where to read and about what read to get know with these functionalities?

Best,
Jacek

Re: Programatically interact with Power BI

Anonymous — Thu, 12 May 2022 01:04:52 GMT

Hi @jaryszek,

You can create a report file that parameterized the connecting string with the query parameter and publish it to the power bi service side. (create report steps seem not able to be achieved programmatically)

Then you can change the parameter on the service side to affect the current data source mapping. (notice: these data sources should have the same data structure as the original report defined)

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

After these steps, you can invoke the export to PDF API to export the current report.

REST API:

Datasets - Update Parameters In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Regards,

Xiaoxin Sheng

Re: Programatically interact with Power BI

jaryszek — Fri, 13 May 2022 06:35:07 GMT

Thank you so much!