Adam shows how you can use the Power BI REST API without writing any code. Then takes it to the next level with PowerShell. Power BI REST API Reference - https://docs.microsoft.com/rest/api/power-bi/ Power BI PowerShell reference - https://docs.microsoft.com/powershell/power-bi/overview?view=powerbi-ps Blog describing $expand use - https://powerbi.microsoft.com/en-us/blog/avoiding-workspace-loops-by-expanding-navigation-properties-in-the-getgroupsasadmin-api/ Download sample PowerShell script Want to download the sample PowerShell script? Hit [...]
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup135 2 Minute Tuesday: https://guyinacu.be/reportbackground Patrick's tech video: https://guyinacu.be/slicerperf Adam's tech video: https://guyinacu.be/nextlevelbutton Sources Creating a Table Heatmap in Power BI (@HavensBI) Using The “Skip Test Connection” Option For Power BI Data Sources To Avoid Scheduled Refresh Failures (@cwebb_bi) Announcing Query Caching in [...]
You need an Embed Token for the Power BI Embedded Playground, but you don't want to write code. Adam shows you how to easily get an access token with no code using PowerShell. Power BI Embedded Playground Power BI REST API Embed Token API Power BI PowerShell CMDLET
Learn how you can block free signups for the Power BI service. Free signups are also what are referred to as viral signups. This action can affect more than just Power BI, so be careful.
In this video, Patrick looks at how to create a Power BI streaming dataset and use that to create a real-time dashboard. You can easily use something like PowerShell to push data into the Power BI streaming dataset. Demo files
In this video, Adam looks at how you can create mail-enabled security groups via PowerShell and copy members from an Office 365 Unified group into that new group. This came about based on a limitation that within Power BI, you can't list O365 Unified groups (what back App workspaces) from the people picker for access [...]
I posted a video on the Power BI YouTube channel for using PowerShel and the Audit log to assign Power BI Pro licenses. In this video, I give you a few other options instead of automating off of the audit log. Main video: Using Power BI Audit Log and PowerShell to assign Power BI Pro [...]
Auditing with Power BI has been available for a few months within the US and more recently within all regions except Europe and Australia as a preview. This provides auditing on certain events to understand what your organization is doing with the service. The new activity that has been added is when a free user [...]