fbpx

Why can’t Power BI connect to my cloud source???

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

Why can’t Power BI connect to my cloud source???2022-06-23T10:01:07-05:00

From Decomposition Tree to Details in Power BI!!!

The Decomposition Tree is an amazing visual but how can we get to the details. Where's my drill through? Patrick walks you through how you can set this up in Power BI Desktop! Create and view decomposition tree visuals in Power BI https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-decomposition-tree Set up drillthrough in Power BI reports https://docs.microsoft.com/power-bi/create-reports/desktop-drillthrough Wyn Hopkins https://twitter.com/wynhopkins

From Decomposition Tree to Details in Power BI!!!2022-06-22T09:03:00-05:00

Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!

Trying to get started with a Modern Data Lakehouse? There are so many options today. Where do you even begin? Patrick and Stijn help you get a handle on it with Azure Synapse Analytics! Stijn Wynants https://twitter.com/SQLStijn Building a Modern Lakehouse Data Warehouse with Azure Synapse Analytics: Moving your Database to the lake https://sql-stijn.com/2022/06/14/building-a-modern-lakehouse-data-warehouse-with-azure-synapse-analytics-moving-your-database-to-the-lake/ Pipelines [...]

Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!2022-06-21T08:40:18-05:00

Publish from Power BI Desktop for External Users

Have you ever wanted to publish from Power BI Desktop to a different organization? External Users publishing!!! Adam shows you how you can log in as an external user in Power BI Desktop and then publish. BANANAS!!! Ross Couldrey LinkedIn: https://www.linkedin.com/in/rosscouldrey/ Distribute Power BI content to external guest users using Azure Active Directory B2B https://docs.microsoft.com/power-bi/guidance/whitepaper-azure-b2b-power-bi

Publish from Power BI Desktop for External Users2022-06-16T07:55:32-05:00

What tool do you use to optimize your Power BI dataset?

Need some help optimizing your Power BI Dataset but don't want to hand over your Power BI Desktop file? Patrick shows you some tools to get information to help with optimizing assistance! These are tools we use EVERYDAY! DAX Studio https://daxstudio.org/ Bravo for Power BI https://bravo.bi/ Tabular Editor 3 https://tabulareditor.com/

What tool do you use to optimize your Power BI dataset?2022-06-15T07:54:00-05:00

What are the main tools for Azure Synapse and SQL???

Getting started with Azure Synapse Analytics or Azure SQL Database? Or even Microsoft SQL Server in general? Patrick shows you how to use some of the common tools and be able to connect to your instance! Download SQL Server Management Studio https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms Download and install Azure Data Studio https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio

What are the main tools for Azure Synapse and SQL???2022-06-14T07:19:11-05:00

Answering your datamart questions

You've got a LOT of questions about datamarts in Power BI! Adam answers a few that we've seen popping up. Giving his thoughts on these questions. Introduction to datamarts https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview Comparing dataflows to datamarts https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview#comparing-dataflows-to-datamarts When to use dataflows https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-introduction-self-service#when-to-use-dataflows

Answering your datamart questions2022-06-02T07:00:21-05:00

Power BI dataflows vs datamarts: What’s the difference???

Are you excited about datamart in Power BI? What about dataflows? Should you even use dataflows anymore? Do we just datamart all the things? Let's have a look! Introduction to datamarts https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview Comparing dataflows to datamarts https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview#comparing-dataflows-to-datamarts When to use dataflows https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-introduction-self-service#when-to-use-dataflows Dataflows with benefits https://ssbipolar.com/2022/05/25/dataflows-with-benefits/

Power BI dataflows vs datamarts: What’s the difference???2022-06-01T07:56:39-05:00

Writing your first SQL Statement!

New to writing T-SQL? Patrick walks you through your first SQL statement. Great foundation to have when working with SQL Server or Azure Synapse Analytics! Download SQL Server Management Studio https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms Download and install Azure Data Studio https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio Transact-SQL Reference (Database Engine) https://docs.microsoft.com/sql/t-sql/language-reference?view=sql-server-ver16

Writing your first SQL Statement!2022-05-31T08:36:02-05:00

Reduce the queries being sent with Incremental Refresh in Power BI!

Have you noticed some extra queries being sent when using Incremental Refresh in Power BI? Patrick explains why this could happen and a potential workaround. Privacy Levels: https://docs.microsoft.com/power-bi/enterprise/desktop-privacy-levels

Reduce the queries being sent with Incremental Refresh in Power BI!2022-05-26T07:18:26-05:00
Go to Top