Report Automation PowerShell REST API

[athomp15]

Hi,

I've been working with the Power BI PowerShell model PowerBIPS to try and do some simple automation, but am currently failing.  I was looking for a way of importing a templated PBIX (or PBIT) file, then loading it with data, ideally all through PowerShell.  It seems you can't automate the upload of a PBIT file, so was looking to import a PBIX file and cleaning down the tables.   When the file is imported, the dataset doesnt seem 100% accessible through the REST API?   any help on this would be greatly recieve

Can I use the REST API o import a pbxi file, then update table rows?  Or if i create a dataset through the REST API and populate tables with data, how can I automate the creation of a report ?

Thanks 

Alex

[Eric_Zhang]

@athomp15

You can creat tables and add rows via REST API to the datasets which also are created via REST.

AFAIK, there's no way automation way to create a report.  Please check this idea Create a report/dashboard programatically using the API  and vote it up.

At this moment, you can create a dataset via REST API and design a report in Power BI Service. Then update the data via REST API.

[athomp15]

Thanks for the response @Eric_Zhang.  I've taken a look through the information availble on the API, what's not clear is what I can do to the datasets (tables etc) when I import a PBXI file.  Currently it shows that there are not tables in the datasets belonging to the imported reports.  

List of data sets from imported PBIX files

Which seems that I can either use the API to automate the data - then build the report manually, or template the reports using Power BI desktop, but then not have any flexability around updating it's data using the API.

[Eric_Zhang · Accepted solution]

---

@athomp15 wrote:

Thanks for the response @Eric_Zhang.  I've taken a look through the information availble on the API, what's not clear is what I can do to the datasets (tables etc) when I import a PBXI file.  Currently it shows that there are not tables in the datasets belonging to the imported reports.  

List of data sets from imported PBIX files

Which seems that I can either use the API to automate the data - then build the report manually, or template the reports using Power BI desktop, but then not have any flexability around updating it's data using the API.

---

That seems the limitation. As I suggested, you can creat tables and add rows via REST API to the datasets which also are created via REST, neither to the datasets published by PBI desktop nor to the ones imported.

I think the flexiability is making sense and maybe the product team is working on some feature. Meanwhile you can submit your idea at Power BI Ideas.

You can also check this idea Allow to update the dataset (tables) of a published desktop via API and vote it up.

[Sunkari]

@Eric_Zhang; Can we automate publishing/deployment of reports to app workspace? (Through Rest API or Through Power Shell )

[Anonymous]

Hi

Did you get any anwer on your last questio

---

---

n. Actually I am also trying to achieve it.

Let me know if you have any ideas.

Regards

Shilpi

[Anonymous]

Hi

Did you get any anwer on your last question. Actually I am also trying to achieve it.

Let me know if you have any ideas.

Regards

Shilpi