fbpx

🔴 Power BI tips from the Pros – LIVE w/ Marco Russo (Mar 5, 2022) (Member Chat 2nd Half)

💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority 👉 Do NOT re-post your questions! We'll get to as many questions [...]

🔴 Power BI tips from the Pros – LIVE w/ Marco Russo (Mar 5, 2022) (Member Chat 2nd Half)2022-08-21T14:49:16-05:00

Dealing with orphaned Power BI workspaces

What are orphaned Power BI Workspaces and how do you get rid of them? What if you have a lot of them? Adam walks through some options including a PowerShell script! Delete Group/Workspace API: https://docs.microsoft.com/rest/api/power-bi/groups/delete-group AddUserAsAdmin API https://docs.microsoft.com/rest/api/power-bi/admin/groups-add-user-as-admin Power BI PowerShell CMDLETs https://docs.microsoft.com/powershell/power-bi/overview?view=powerbi-ps PowerShell Script: https://github.com/itsnotaboutthecell/PowerBI-cmdlets/blob/master/notebooks/PowerBI_Delete_Orphan_WS.ps1

Dealing with orphaned Power BI workspaces2022-03-03T07:09:40-05:00

Create Hybrid Tables with Tabular Editor for Power BI? YES!!!

Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can do just that in Tabular Editor! --This Year let Source = Sql.Databases("servername"), AdventureWorksDW = Source{[Name="databasename"]}[Data], internetsales = AdventureWorksDW{[Schema="dbo",Item="pbi_InternetSales"]}[Data], thisyear = Table.SelectRows(internetsales, each Date.IsInCurrentYear([OrderDate])) in thisyear --Last [...]

Create Hybrid Tables with Tabular Editor for Power BI? YES!!!2022-03-02T08:30:35-05:00
Go to Top