Gateway sprawl in Power BI can be a problem for organizations looking to govern what data can be refreshed. Learn how you can govern the Personal Gateway to keep it under control.

Set-DataGatewayTenantPolicy PowerShell Reference
https://docs.microsoft.com/powershell/module/datagateway/set-datagatewaytenantpolicy?view=datagateway-ps

Get-DataGatewayTenantPolicy PowerShell Reference
<a href="https://docs.microsoft.com/powershell/module/datagateway/get-datagatewaytenantpolicy?view=datagateway-ps" Continue reading “Personal Gateway governance in Power BI” →

Join us live as we answer your questions about Power BI! With special guest, Matthew Roche!

Connect with Matthew:
Twitter: https://twitter.com/SQLAllFather
YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ
Website: https://ssbipolar.com/

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public Continue reading “🔴 Closing out 2021 – LIVE w/ Matthew Roche (Dec 18, 2021)” →

Ever run into a Parameter error when trying to refresh a partition in Power BI? It can drive you BANANAS! Patrick explains how to get around it and refresh successfully.

📢 Become a member: https://guyinacu.be/membership

*******************

Want to Continue reading “Avoid Parameter Error when refreshing a Power BI partition” →

Tired of all those buttons for bookmarks in your Power BI reports? Patrick shows you how to use the Bookmark Navigator to easily get going and get rid of all those buttons!

Create page and button navigators
https://docs.microsoft.com/en-us/power-bi/create-reports/button-navigators

📢 Become Continue reading “Use Bookmark Navigator in Power BI to easily move through Bookmarks” →

Sometimes your data isn’t shaped the right way. Have you tried the Pivot or Unpivot methods in Power Query? They can help get your data looking the right way for your Power BI reports!

Pivot columns
https://docs.microsoft.com/en-us/power-query/pivot-columns

Unpivot columns
<a href="https://docs.microsoft.com/en-us/power-query/unpivot-column" Continue reading “To Pivot or Unpivot? That is the question!” →

Thinking you don’t need a date table in Power BI? What about Fiscal month? Patrick shows how you could potentially go about adding that without a full date table.

But really, use a central date table 😎

Do you need a date Continue reading “No Calendar Table? How to add Fiscal Month and Sort in Power BI?” →