Programatically interact with Power BI

[jaryszek]

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

[jaryszek]

Thank you so much!

[v-shex-msft · Accepted solution]

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