Call any Power BI REST API with PowerShell

[@RB26_Aces]

Is there a way to run an API call within PowerQuery, for example: to pull in that refresh history json text, so your dataset refresh actually grabs the current refresh history?

[@JorgeEscobarMX]

This is the best tutorial ever on how to call power BI api. I'm using Python with the requests module for this. This is a good start. I'm also looking how to query power bi datasets using the power bi api.

[@davidcousins8407]

Okay, I'm formally calling it "Mister Spinny" in our documentation :D

[@buddhigupta3557]

What about using Power Automate to run these API for automation? Can this be done easily?

[@BryantAveyLLC]

This is cool, Adam. the PS REST API for Power BI Service would allow you to have more than eight scheduled refreshes in a day, by just scheduling the Power Shell command to trigger a PBI refresh anytime you want, like every 1/2 hour throughout the day, etc. Love it.

[@Doffskii]

The refresh limit includes both scheduled and api refresh.

[@davidcousins8407]

Only if you have Premium!

[@christopherjohnson3755]

Tested this a while back with Power Automate, and the 8 refresh limit still applies.

[@MrKor4k]

Nice thing you can use REST API with Power Automate. All you need make Azure App with access to base endpoint then you can create custom connector with any url you want.

[@kevinnikolai6086]

Does it mean I can call any API (Power BI Rest API, Azure API's) with Power Automate ?

[@Bharath_PBI]

Thank you. Can you do a video exploring PBIRS Power shell cmdlets, setup, config, prerequisites etc. I see users asking for it, probably swagger hub can get them but a video could be helpful.

[@jamess7033]

This was literally going to be my next Google Search after watching this Video, lol.

[@eesa4013]

This is my first time hearing about Power BI REST APIs

[@joeseroski1095]

Loved it. Didn't know you could do these things.

[@Based-Pharaoh]

Nice video. Currently trying to implement this solution within Python to export an xlsx file which would significantly help solve my current obstacle to automate a specific task at my current organization

[@greglilly3866]

I just converted a Powershell based application with these REST API libraries to a Python application. Works magnitudes better than the Powershell method. I'm pulling down the JSON data and transforming it to Datafram and writing to the Snowflake Cloud Data Warehouse.

[@eagillum]

Can you do a video on coding in regular API's? Like not Power BI ones? I have a couple JSON ones I'd like to insert into ... power query somehow...(?)

[@MrPranavpatel72]

Yes Adam, we already have integrated PBI dataset refresh post our ETL in ADF, which saved a lot of manual refresh of dataset And also we are getting an email alert as well post refresh succeeds or fails. Really great feature though. Cheers!!

[@soumyadeepmondal6130]

Hi! I am currently thinking about using PowerShell to refresh dataflow and check if that dataflow finishes refresh and if yes, then trigger a 2nd dataflow and so, on. I have a few questions if you don't mind answering them. 1st, where are you running your powershell code? Like uploaded in a server or something so that it can run automatically at a scheduled time? I saw that we can upload our powershell code in azure automation but for now my client's organisation has not provided azure subscription, so won't be able to use that. 2nd, Can you send the actual code which is working at your end to see how you are configuring email trigger post failure or success? Thanks!!

[@gayathrigopalakrishnann7560]

Hello ... is there a way to have LIve connection to API connection? we are looking for real time data..

[@danielgreenberg5257]

What screen capture software do you use to capture your mouse clicks with outlines/rectangles/etc?

[@lilynguyen2382]

This is my first time hearing about Powershell. Is this free? Is anybody allowed to use this?

[@vinaymishra06]

Can we get the workspace id dynamically? if yes then can we use poweshell script anyhow to embed the report to web application? This only for the trigerring refresh.

[@ihafidh]

Thank you for mentioning that not all APIs are supported via a service principal. The MS documentation does not mention that.

[@LeavingConformity]

Thanks for this overview! I need to figure out how to use the REST API to return a list of datasets from a couple of specific workspaces that failed in their most recent refresh attempt. Is there a way to do that?

[@rihamfathy3521]

I have same problem

[@BjornV1976]

Now i can build a Power BI with statistics about al the power BI refreshes. :)

[@eth6706]

Please tell me this works on PBIRS

[@etherlords88]

If I use -Url, it gives me error, if I use the commands separately like Invoke--powerbirestmethod then enter, then paste the url , enter, then type get and enter, it works. But it does not work if I put everything altogether! Any idea? 😐

[@glasskitesmedia]

Have you logged in first? Try adding this before: Login-PowerBI

[@kevinnikolai6086]

Can you run the Powershell script (Datasets - Refresh Dataset In Group) from Power BI or are you forced to run it from Windows 10 / On-Premise Server / Azure ?

[@ruchigupta1536]

following

[@noahhadro8213]

I am getting this alert when I try to log in with powershell? The term 'Login-PowerBIServiceAccount' is not recognized as the name of a cmdlet

[@notoriousft]

Try Login-PowerBI instead.

[@DanielWeikert]

Unable to test. The login itself does not work for me AADSTS50011: The reply URL specified in the request does not match the reply URLs configured for the application

[@Bharath_PBI]

Probably, to get the right bit version (32 or 64 bit Power shell)

[@vallabhiajay8294]

Hi I am trying call powerbi dataset refresh using windows powershell, expect refresh all commands worked but when execute last command of invoke powerbi.I'm running error can anyone help

[@vallabhiajay8294]

Running into this error message + CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRest Method], AggregateException + FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod

[@andriyk7222]

thanks for sharing!

[@visheshjjain]

Can we call a REST API from inside a PBI Service Report?

[@christopherjohnson3755]

You can build a Power Automate custom connector around the Power BI REST API, and then trigger flows from within your report using the Power Automate visual.

[@davidcousins8407]

Yes, you can use Power Query to retrieve data from the REST API and this works from within the PBI service.

[@visheshjjain]

@@davidcousins8407 I’m not sure how that’ll work, as I’m trying to refresh the report on the service using the REST API. Do you have any suggestions or links to articles/videos regarding this?

[@christopherjohnson3755]

@@visheshjjain for this there is a built in action in Power Automate. You will need to add a Power Automate visual to your report, create a flow from within that visual, and then add the refresh action to this flow. It should be fairly obvious at each stage what to do. David's suggestion is correct as you can pull in things like refresh histories, however you can't trigger things with that method.

[@miragliag]

@@davidcousins8407 can you share a powerquery example?

[@Phoenixspin]

I'm not rude. I refuse to bother the API when it's resting.

[@mohammadsaleh4767]

Q: how to connect lightspeed api with power bi.

[@TJTHEFOOTBALLPROPHET]

MAJOR GAME CHANGER!

[@michaelc2712]

Where’s the best place to report a bug in the REST API?

[@musl1618]

Первый!