Guy in a Cube
76 FOLLOWERS
Weekly videos to help you master business intelligence on the Microsoft stack! We share tips and tricks, answer questions, and are more focused on Power BI, Reporting Services, and Analysis Services. Guy in a Cube is all about helping you master business analytics on the Microsoft Business analytics stack to allow you to drive business growth.
Guy in a Cube
6d ago
If you’re in Power BI Desktop, how do you actually connect to Microsoft Fabric items like a lakehouse or warehouse? Adam walks you through different options and how this relates to various connectors.
The post How to connect to Microsoft Fabric Items from Power BI Desktop? appeared first on Guy in a Cube ..read more
Guy in a Cube
6d ago
Direct Lake in Power BI could possibly fall back to DirectQuery. Do you understand why this would happen and when? Patrick walks you though what you need to know when leveraging data from OneLake in Microsoft Fabric.
Direct Lake
https://learn.microsoft.com/power-bi/enterprise/directlake-overview
The post Decoding Direct Lake: The Truth Behind DirectQuery Fallback appeared first on Guy in a Cube ..read more
Guy in a Cube
1w ago
You disabled Include In Refresh in Power Query, but it’s still being used? And you still need to provide credentials for your Power BI Semantic Mode? What?!? Adam breaks down what’s going on.
Managing query refresh in Power BI
https://learn.microsoft.com/power-bi/connect-data/refresh-include-in-report-refresh
The post Include in Refresh can trip you up within Power Query appeared first on Guy in a Cube ..read more
Guy in a Cube
2w ago
It’s been a long time coming but Visual Calculations within Power BI are here!!! Jay joins us to get us started on using Visual Calcs within our reports.
Share your thoughts on visual calculations (preview)
https://aka.ms/visual-calculations-feedback
Using visual calculations (preview)
https://learn.microsoft.com/power-bi/transform-model/desktop-visual-calculations-overview
Jeroen (Jay) ter Heerdt
https://twitter.com/JayPowerBI
https://www.linkedin.com/in/jeroenterheerdt/
https://www.dutchdatadude.com/
The post Getting started with Visual Calcs in Power BI appeared first on Guy in a Cube ..read more
Guy in a Cube
3w ago
Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.
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 as we can.
If you SPAM your question, you will be put in timeout
The post ? Microsoft Fabric / Power BI Q&A – LIVE (Mar 2, 2024) (Member Chat 2nd Half ..read more
Guy in a Cube
3w ago
Who needs NOCODE? Patrick takes you on a journey where you can extract ZIP files within a Notebook in Microsoft Fabric. Also found a very cool feature in Notebooks!
The post All Code!!! Extract ZIP files with Notebooks in Microsoft Fabric appeared first on Guy in a Cube ..read more
Guy in a Cube
1M ago
Need to extract ZIP files and don’t want to write code? Adam walks you through how you can do this with Pipelines and dataflows within Microsoft Fabric. A NO CODE approach!
The post NO CODE extract ZIP files with Pipelines in Microsoft Fabric appeared first on Guy in a Cube ..read more
Guy in a Cube
1M ago
Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.
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 as we can.
If you SPAM your question, you will be put in timeout
The post ? Microsoft Fabric / Power BI Q&A – LIVE (Feb 24, 2023) (Member Chat 2nd Half ..read more
Guy in a Cube
1M ago
Join Patrick as he explores Real-Time Analytics (RTA) in Microsoft Fabric by creating an event stream into a KQL Database. It only takes a few clicks!
What is RTA:
https://learn.microsoft.com/fabric/real-time-analytics/overview
Event Streams overview:
https://learn.microsoft.com/fabric/real-time-analytics/event-streams/overview
The post Creating your first EVENTSTREAM in Microsoft Fabric appeared first on Guy in a Cube ..read more
Guy in a Cube
1M ago
When you add a column to your lakehouse in Microsoft Fabric, why isn’t is showing up in the Power BI Semantic Model? Patrick shows you how to get it there!
Gaston Cruz
https://twitter.com/GastonFCruz
https://www.linkedin.com/in/gastoncruz/
The post Adding a column to your Lakehouse? Where is it in the Semantic Model??? appeared first on Guy in a Cube ..read more