Not sure what a REST API is? Or what you can do with them in Power BI? Find out how you can easily take advantage of them without having to write a bunch of code. Use PowerShell instead!
REST API Reference Documentation
https://docs.microsoft.com/rest/api/power-bi/
Power BI PowerShell Reference Documentation
https://docs.microsoft.com/powershell/power-bi/overview
Use Microsoft Flow, and other options, to refresh your Power BI dataset
https://www.youtube.com/watch?v=ClmZ-8p6x9g
Refresh Dataset In Group API
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset-in-group
Refresh History in Group API
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history-in-group
Get Pages in Group
https://docs.microsoft.com/en-us/rest/api/power-bi/reports/get-pages-in-group
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#PowerBI #PowerShell #GuyInACube
source
23 replies on “Call any Power BI REST API with PowerShell”
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 ?
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
Yes, Adam. We are using Powershell to automate the whole workspaces reports refreshes and export the rdl report to local drive and send the same via email as PDF/ EXCELL attachment to required end users
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?
Thank you for mentioning that not all APIs are supported via a service principal. The MS documentation does not mention that.
What screen capture software do you use to capture your mouse clicks with outlines/rectangles/etc?
OMG, EXACTLY WHAT I NEEDED
—————————————————–⏯Cliklink———————————————————-THE NEW VIDEOS SEX 🎬ⓉⓊⒷⒺⓈⒺⓍ🔞————————————————————————————————————————————————————————MY 18+ PHOTOS HE RE 💜 👉 https://ok.me/OTFy?GB/HDRCam私のヌードセックス トップAVビデオに参加する ❤️ライブ配信の再編ありがとうです！この日のライブ配信は、かならりやばかったですね！１万人を超える人が見ていたもんね（笑）やっぱり人参最高！まさかのカメラ切り忘れでやら1かしたのもドキドキでした！今後は気を付けないとね. .
!😉💝❤️#今後は気をライブ配信の再編ありがとうです！#この日のライブ配信は、#かならりやばかったですね！#１万人を超える人が見ていたも
ん（#笑）#やっぱり人参最高！#まさかのカメラ切り忘れでやら1かしたのもドキドキでした $
#今後は気をライブ配信の再編ありがとうです！ #この日のライブ配信は、W #かならりやばかったですね！ !
#１万人を超える人が見ていたもん（ #笑）#やっぱり人参最高%！
#まさかのカメラ切り忘れでやら1かしたのもドキドキでした #垃圾W#再編ありがとうです！#いたもん（#笑）在整個人類歷史上，強者，富人和具有狡猾特質的人捕食部落，氏族，城鎮，城市和鄉村中的弱者，無'守和貧窮成員。然而，人類的生存意願迫使那sfdsd些被拒絕，被剝奪或摧毀的基本需求的人們找到了一種生活方式，並繼續將其DNA融入不斷發展的人類社會。. 說到食物，不要以為那些被拒絕的人只吃垃圾。相反，他們學會了在被忽視的肉類和蔬菜中尋找營養。他們學會了清潔，切塊，調味和慢燉慢燉的野菜和肉類，在食品`.
I'm not rude. I refuse to bother the API when it's resting.
This is my first time hearing about Powershell. Is this free? Is anybody allowed to use this?
What about using Power Automate to run these API for automation? Can this be done easily?
Can we call a REST API from inside a PBI Service Report?
Now i can build a Power BI with statistics about al the power BI refreshes. 🙂
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.
Please tell me this works on PBIRS
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.
Okay, I'm formally calling it "Mister Spinny" in our documentation 😀
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
This is my first time hearing about Power BI REST APIs
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
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.
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!!
Loved it. Didn't know you could do these things.
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.