You have a cloud data source like Azure SQL Database. Why can't Power BI connect to it? They are both in the cloud! Adam shows you some things to consider and options you have! What is an on-premises data gateway? https://docs.microsoft.com/data-integration/gateway/service-gateway-onprem What is a virtual network (VNet) data gateway? https://docs.microsoft.com/data-integration/vnet/overview
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 https://docs.microsoft.com/powershell/module/datagateway/get-datagatewaytenantpolicy?view=datagateway-ps Set-DataGatewayInstaller PowerShell Reference https://docs.microsoft.com/powershell/module/datagateway/set-datagatewayinstaller?view=datagateway-ps Get-DataGatewayInstaller PowerShell Reference https://docs.microsoft.com/powershell/module/datagateway/get-datagatewayinstaller?view=datagateway-ps Azure AD to Microsoft Graph migration https://docs.microsoft.com/powershell/azure/azps-msgraph-migration-changes?view=azps-6.6.0
Can a Power BI Dataset be setup to refresh without an actual user? It would be great from an automation perspective and to avoid being tied to someone specific. Adam digs in. Service Principal Video: https://www.youtube.com/watch?v=1SO19uik1rw Add-DataGatewayClusterUser (DataGateway CMDLET - Add to Admin List) https://docs.microsoft.com/powershell/module/datagateway/add-datagatewayclusteruser?view=datagateway-ps Add-DataGatewayClusterDatasourceUser (DataGateway CMDLET - Add to Datasource User list) https://docs.microsoft.com/powershell/module/datagateway/add-datagatewayclusterdatasourceuser?view=datagateway-ps [...]
Thanks for watching this week's Power BI news roundup! Patrick's tech video: https://guyinacu.be/handledeletessample Adam's tech video: https://guyinacu.be/premiumgen2 🔴Live Replay: https://guyinacu.be/live035 📢 Become a member: https://guyinacu.be/membership Sources Why Excel Needs Power BI to Solve Your Data Analysis Issues (@CSGPro) New Microsoft data governance product: Azure Purview (@JamesSerra) Tabular Editor 3 with Daniel Otykier [...]
Let's dig into the Power BI gateway and Single Sign-On (SSO) using Kerberos! This can be used for both DirectQuery and refreshing a Power BI dataset. Documentation: https://docs.microsoft.com/power-bi/service-gateway-sso-overview Download Cube Sheet
Confused about what a Power BI Gateway cluster is? Have your On-Premises Data Gateway installed but it's overloaded? This video is for you! Documentation: https://docs.microsoft.com/data-integration/gateway/service-gateway-high-availability-clusters PowerShell: https://docs.microsoft.com/data-integration/gateway/service-gateway-powershell-support Download Cube Sheet
Join us live as we talk about Power BI gateways! The what and why regarding them and some things to consider when using a gateway.
Get to know what the Power BI Gateway is along with how to get it setup for scheduled refresh of imported data. Gateway Documentation: https://docs.microsoft.com/power-bi/service-gateway-onprem Gateway sizing: https://docs.microsoft.com/power-bi/guidance/gateway-onprem-sizing Download Free Cube Sheet
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup169 2 Minute Tuesday: https://guyinacu.be/rlsmembers Patrick's tech video: https://guyinacu.be/rlsexport Adam's tech video: https://guyinacu.be/customfont 🔴 Recorded Live Stream: https://guyinacu.be/pbiconferences 📢 Become a member: https://guyinacu.be/membership Sources Why and how to Keep Dimensions & Facts tables separate – DAX modeling (@theexcelclub) Power BI: [...]
Adam looks at your refresh options for Power BI datasets. Including Microsoft Flow! https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
