topic Re: Power BI REST API (Read Only) in Developer

Power BI REST API (Read Only)

Nos — Sun, 05 Sep 2021 18:32:56 GMT

Hiya,

I have Power BI reports and datasets pulling data from our on prem MS Access database.

I would like to have an API setup to pull data from the Power BI reports and datasets so that my clients won't have to consume our data via spreadsheet attachments in email. Is this even possible? Sorry if this has been answered on another thread and if so, please let me have the URL.

Thanks
Nos

Re: Power BI REST API (Read Only)

lbendlin — Mon, 06 Sep 2021 18:09:15 GMT

There is an option but it depends on the capacity type you are using.

Please refer to the blog entry Announcing the public preview of Power BI REST API support for DAX Queries | Microsoft Power BI Blog | Microsoft Power BI

Re: Power BI REST API (Read Only)

Nos — Mon, 06 Sep 2021 18:41:07 GMT

Thanks very much!

I will try to implement one for read reports but this would be a daunting task no doubt.

Re: Power BI REST API (Read Only)

lbendlin — Mon, 06 Sep 2021 18:44:43 GMT

If you want something a little more daunting you can also use the XMLA end point interface to run your DAX queries.

Hopefully your MS Access database is not used for anything business critical?

Re: Power BI REST API (Read Only)

Nos — Mon, 06 Sep 2021 19:52:34 GMT

Actually, it is the main business database and it holds the most critical databases. I will PM you if you don't mind?

Re: Power BI REST API (Read Only)

lbendlin — Mon, 06 Sep 2021 23:39:36 GMT

You better have frequent backups. I have seen grownups cry when they were writing beyond the 2GB size limit and the database went poof!

Re: Power BI REST API (Read Only)

Nos — Tue, 07 Sep 2021 19:10:36 GMT

Sure will. Haha... backups never to be neglected