Categories
Video

Call any Power BI REST API with PowerShell



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”

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?

OMG, EXACTLY WHAT I NEEDED

—————————————————–⏯Cliklink———————————————————-THE NEW VIDEOS SEX 🎬ⓉⓊⒷⒺⓈⒺⓍ🔞———————————————————————————————————————————————————————— MY 18+ PHOTOS HE RE 💜 👉 https://ok.me/OTFy?GB/HDRCam私のヌードセックス トップAVビデオに参加する ❤️

ライブ配信の再編ありがとうです!この日のライブ配信は、かならりやばかったですね!1万人を超える人が見ていたもんね(笑)やっぱり人参最高!まさかのカメラ切り忘れでやら1かしたのもドキドキでした!今後は気を付けないとね. .

!😉💝❤️#今後は気をライブ配信の再編ありがとうです!#この日のライブ配信は、#かならりやばかったですね!#1万人を超える人が見ていたも

ん(#笑)#やっぱり人参最高!#まさかのカメラ切り忘れでやら1かしたのもドキドキでした $

#今後は気をライブ配信の再編ありがとうです! #この日のライブ配信は、W #かならりやばかったですね! !

#1万人を超える人が見ていたもん( #笑)#やっぱり人参最高%!

#まさかのカメラ切り忘れでやら1かしたのもドキドキでした #垃圾W#再編ありがとうです!#いたもん(#笑)在整個人類歷史上,強者,富人和具有狡猾特質的人捕食部落,氏族,城鎮,城市和鄉村中的弱者,無'守和貧窮成員。然而,人類的生存意願迫使那sfdsd些被拒絕,被剝奪或摧毀的基本需求的人們找到了一種生活方式,並繼續將其DNA融入不斷發展的人類社會。. 說到食物,不要以為那些被拒絕的人只吃垃圾。相反,他們學會了在被忽視的肉類和蔬菜中尋找營養。他們學會了清潔,切塊,調味和慢燉慢燉的野菜和肉類,在食品`.

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.

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!!

Leave a Reply

Your email address will not be published. Required fields are marked *