Category: Power Query

Get started with the On-Premises Data Gateway in Microsoft Fabric

Posted on by Annie D

Trying to leverage on-premises data? Can’t connect to a cloud source because of firewalls or private networks? Learn how you can use the On-Premises Data Gateway with Microsoft Fabric to get the data you need!

What is an on-premises data gateway?
https://learn.microsoft.com/data-integration/gateway/service-gateway-onprem

On-premises data gateway architecture
https://learn.microsoft.com/data-integration/gateway/service-gateway-onprem-indepth

Install an on-premises data gateway
https://learn.microsoft.com/data-integration/gateway/service-gateway-install

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

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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— <a Continue reading “Get started with the On-Premises Data Gateway in Microsoft Fabric” →

Get a custom endpoint without creating an EventHub for EventStreams

Posted on by Annie D

No need to create a custom event hub when leveraging eventstreams in Microsoft Fabric. Just create a custom endpoint instead! Patrick shows you how.

Add custom endpoint source to an eventstream
https://learn.microsoft.com/fabric/real-time-intelligence/event-streams/add-source-custom-app?pivots=enhanced-capabilities

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

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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools Continue reading “Get a custom endpoint without creating an EventHub for EventStreams” →

Update Data Sources within Deployment Pipelines

Posted on by Annie D

Making use of a Deployment Pipeline within Microsoft Fabric? Not sure how to update data sources for your Power BI semantic model as you move through stages? Adam has you covered!

Get started with deployment pipelines
https://learn.microsoft.com/fabric/cicd/deployment-pipelines/get-started-with-deployment-pipelines?tabs=from-fabric

Create deployment rules
https://learn.microsoft.com/fabric/cicd/deployment-pipelines/create-rules

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

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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— <a href="https://www.instagram.com/guyinacube/" Continue reading “Update Data Sources within Deployment Pipelines” →

Install Power BI Desktop the RIGHT WAY! (2024)

Posted on by Annie D

Want to get started with Power BI but not sure how? Start by installing Power BI Desktop! Adam walks you through how to install it and some things to do immediately after!

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

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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page Continue reading “Install Power BI Desktop the RIGHT WAY! (2024)” →

Excel Slow Workbook Speeds Up Instantly With ForceFullCalculation Toggled Off – 2644

Posted on by Annie D

Microsoft Excel Tutorial: Make workbook calculate faster by toggling off the ForceFullCalculation setting.

Welcome back to MrExcel! Today, I’ve got an incredible tip that can make your Excel workbooks run dramatically faster. Have you ever heard of ActiveWorkbook.ForceFullCalculation = False? Probably not, because it’s a setting that’s rarely documented. But it can make a huge difference in calculation speed, as shown in this example sent by Matt from Chicago, a member of the MrExcel message board.

Matt provided us with a file containing 7,000 rows and 27 columns, which is just a fraction of the size of his client’s actual files. With Continue reading “Excel Slow Workbook Speeds Up Instantly With ForceFullCalculation Toggled Off – 2644” →

On-premises data with Data Factory in Microsoft Fabric

Posted on by Annie D

Do you have on-premises data like a SQL Server? Want to leverage a pipeline within Data Factory in Microsoft Fabric? Patrick shows you have to get going and set that up!

How to access on-premises data sources in Data Factory for Microsoft Fabric
https://learn.microsoft.com/fabric/data-factory/how-to-access-on-premises-data

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

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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— Continue reading “On-premises data with Data Factory in Microsoft Fabric” →

Excel – RegEx Building Blocks – 2643

Posted on by Annie D

Microsoft Excel Tutorial: Learning the Building Blocks for RegEx in Excel
Learn the basic building blocks of RegEx in Excel.

To download the RegEx Cheat Sheet and workbook from today: https://www.mrexcel.com/youtube/fbHQgDM0P1E/

Welcome back to MrExcel’s YouTube channel! In this video, we’ll dive into the building blocks for mastering Regular Expressions (RegEx) and their integration in Excel. If you find this video helpful, don’t forget to click the Like button below – it helps us reach more viewers. We’ve got over 2,500 videos on various Excel topics, so there’s plenty to explore!

Our focus today is on RegEx, specifically the new functions Continue reading “Excel – RegEx Building Blocks – 2643” →

Excel RegEx Support For Pattern Matching – Episode 2642

Posted on by Annie D

Microsoft Excel Tutorial: Excel Adds RegEx Support for Pattern Matching in Excel.

🎥 Unlocking the Power of RegEx in Excel: New Features Explained! 📊

Hey Excel enthusiasts! 🌟 In today’s video, we’re diving into an exciting new feature: RegEx support in Excel for pattern matching. If you enjoy exploring new Excel functionalities, this is a must-watch! Don’t forget to Like this video to help it reach more people. 👍

🔥 What’s New? 🔥
Excel has introduced three powerful RegEx functions: RegExTest, RegExReplace, and RegExExtract. These functions are set to revolutionize how we handle data patterns. Plus, there are updates to XLOOKUP and XMATCH functions Continue reading “Excel RegEx Support For Pattern Matching – Episode 2642” →

Ditch the whiteboard! Use Microsoft Fabric task flows!

Posted on by Annie D

Tired of drawing out your flow on a whiteboard and it getting erased? Now you can use task flows within Microsoft Fabric to lay things out. Patrick gets you started!

Announcing the public preview of task flows in Microsoft Fabric
https://blog.fabric.microsoft.com/en-us/blog/announcing-the-public-preview-of-task-flows-in-microsoft-fabric?ft=All

Task flows in Microsoft Fabric (preview)
https://learn.microsoft.com/fabric/get-started/task-flow-overview

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

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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— rel=”nofollow”>http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#MicrosoftFabric #Taskflows #GuyInACube

Deliver your Power BI subscriptions to OneDrive or SharePoint!

Posted on by Annie D

We’ve had subscriptions in Power BI for a while but you were limited to just email. NOW you can deliver your subscriptions to OneDrive or SharePoint Online! Patrick shows you how!

Deliver report Subscriptions to OneDrive and SharePoint (Preview)
https://powerbi.microsoft.com/en-us/blog/deliver-report-subscriptions-to-onedrive-sharepoint-preview/

Send large report subscriptions to OneDrive SharePoint (Preview)
https://learn.microsoft.com/power-bi/paginated-reports/paginated-reports-onedrive-sharepoint

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

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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— <a href="http://twitter.com/patrickdba" Continue reading “Deliver your Power BI subscriptions to OneDrive or SharePoint!” →

Expert Tips for Managing OneLake Data Access in Microsoft Fabric

Posted on by Annie D

Learn how to control access to OneLake data the right way in Microsoft Fabric with these security tips. Keep your data safe and secure with these best practices!

OneLake data access roles – Public Preview Announcement
https://blog.fabric.microsoft.com/en-us/blog/9046?ft=All

OneLake security overview
https://learn.microsoft.com/fabric/onelake/security/get-started-security

Role-based access control (RBAC)
https://learn.microsoft.com/fabric/onelake/security/data-access-control-model

Microsoft Fabric security white paper
https://learn.microsoft.com/fabric/security/white-paper-landing-page

Aaron Merrill:
LinkedIn: https://www.linkedin.com/in/aajmerrill/

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

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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— Continue reading “Expert Tips for Managing OneLake Data Access in Microsoft Fabric” →

Leverage RLS with Direct Lake in Microsoft Fabric without access to OneLake

Posted on by Annie D

You don’t want to give your users access to OneLake or the Lakehouse/Warehouse directly, but you still want to use Power BI Direct Lake in Microsoft Fabric. Patrick shows you a way to get this done!

Direct Lake Overview
https://learn.microsoft.com/fabric/get-started/direct-lake-overview

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

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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— Continue reading “Leverage RLS with Direct Lake in Microsoft Fabric without access to OneLake” →