Category: Power Query

What does Microsoft Fabric mean for Power BI?

Posted on by Annie D

You’ve heard the news about Microsoft Fabric but what about Power BI? How does Power BI fit in? Do you need to migrate anything? Can you still do what you were doing? Adam tells you what you need to know!

Direct Lake (PREVIEW)
https://learn.microsoft.com/power-bi/enterprise/directlake-overview

Microsoft Fabric Build 2023 Day 1
https://youtu.be/5jlP0wdEsls

Microsoft Fabric Build 2023 Day 2
https://youtu.be/wdDx0-jvl7w

📢 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 “What does Microsoft Fabric mean for Power BI?” →

Understanding the TIMELINE in DAX Studio

Posted on by Annie D

We brought Marco in to help explain the TIMELINE update within DAX Studio. This can help you understand performance a bit deeper when optimizing your DAX and models. This is one to watch!

DAX Studio
https://daxstudio.org

Marco Russo
https://twitter.com/marcorus
https://www.linkedin.com/in/sqlbi/
https://sqlbi.com

Optimizing DAX Video Course
https://www.sqlbi.com/p/optimizing-dax-video-course/

📢 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
— Continue reading “Understanding the TIMELINE in DAX Studio” →

Create your FIRST Lakehouse in Microsoft Fabric

Posted on by Annie D

You started your journey into Microsoft Fabric. Ted wants to help you understand how to create your first Lakehouse and start getting data into OneLake!

What is a lakehouse in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-engineering/lakehouse-overview

Create a lakehouse in Microsoft Fabric
https://learn.microsoft.com/fabric/data-engineering/create-lakehouse

Ted Vilutis
https://www.linkedin.com/in/tedvilutis/
https://twitter.com/tvilutis

📢 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 #Lakehouse #GuyInACube

🔴 Let’s talk Microsoft Fabric – LIVE w/ Amir Netz (June 10, 2023)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric including Power BI with out guest Amir Netz who is a Microsoft Technical Fellow and CTO/Visionary of Microsoft Fabric. You don’t want to miss this one!

Connect with Amir:
LinkedIn: https://www.linkedin.com/in/amirnetz/
Twitter: https://twitter.com/amirnetz

📢 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

📢 Become a member: https://guyinacu.be/membership Continue reading “🔴 Let’s talk Microsoft Fabric – LIVE w/ Amir Netz (June 10, 2023)” →

Understanding Microsoft Fabric Licensing and Cost (Public Preview)

Posted on by Annie D

Everyone has been asking and now we have some information. Adam breaks down how Microsoft Fabric Licensing and costs work. Helping you get the most out of Fabric!

Announcing Microsoft Fabric capacities are available for purchase
https://blog.fabric.microsoft.com/blog/announcing-microsoft-fabric-capacities-are-available-for-purchase

Microsoft Fabric licenses
https://learn.microsoft.com/fabric/enterprise/licenses

Power BI for US government customers
https://learn.microsoft.com/power-bi/enterprise/service-govus-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
— <a href="http://twitter.com/patrickdba" Continue reading “Understanding Microsoft Fabric Licensing and Cost (Public Preview)” →

Excel Place Local Pictures In Cell Using Formula and a VBA Hack – Episode 2607a

Posted on by Annie D

Microsoft Excel Tutorial: Use Excel VBA to replicate the IMAGE function for images stored locally.

In episode 2606, I showed the new Insert Pictures in Cells and lamented that they did not change the IMAGE function to allow images stored on the local hard drive. Using the VBA Macro in this workbook, you can do it. The VBA is actually better because it remembers the image path and displays it in the formula bar.

To download the workbook or copy the VBA: https://www.mrexcel.com/youtube/0NArag0pV7I/

Table of Contents
(0:00) Enhancing Picture In Cells to use a formula
(0:30) Behind Scenes of 2606
(1:00) Sort Order Continue reading “Excel Place Local Pictures In Cell Using Formula and a VBA Hack – Episode 2607a” →

Use your browser to edit your Power BI dataset within Microsoft Fabric

Posted on by Annie D

More Power BI Desktop capabilities are heading to the service. Modeling in the web is the latest addition. Now Mac users can enjoy editing capabilities! Emily joins us to tell us more!

Edit your data model in the Power BI Service (Preview)
https://powerbi.microsoft.com/blog/edit-your-data-model-in-the-power-bi-service-public-preview-opt-in/

Edit data models in the Power BI service (preview)
https://learn.microsoft.com/power-bi/transform-model/service-edit-data-models

Emily Lisa
https://twitter.com/emilyklisa
https://www.linkedin.com/in/emilyklisa/

📢 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 Continue reading “Use your browser to edit your Power BI dataset within Microsoft Fabric” →

Understanding OneLake within Microsoft Fabric

Posted on by Annie D

The key to Microsoft Fabric is definitely OneLake! OneLake enables the reuse of data within Fabric to help drive all of the engines. One copy of the data! Josh Caplan joins us to help get an understanding of the power of OneLake.

OneLake, the OneDrive for data
https://learn.microsoft.com/fabric/onelake/onelake-overview

OneLake shortcuts
https://learn.microsoft.com/fabric/onelake/onelake-shortcuts

OneLake File Explorer
https://learn.microsoft.com/fabric/onelake/onelake-file-explorer

Josh Caplan:
https://twitter.com/JoshCaplan1984
https://www.linkedin.com/in/josh-caplan-2139a3a6/

📢 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: <a Continue reading “Understanding OneLake within Microsoft Fabric” →

Excel – Picture Place In Cell – Episode 2606

Posted on by Annie D

Microsoft Excel Tutorial – new feature to place a picture in a cell in Excel.
Can the Excel IMAGE function use a local hard drive? Not yet.
New Excel VBA method: InsertPictureInCell
Insert Many Pictures in Excel in one command.
Feature Requests:
Expose a VBA property to show original source of the image
Allow IMAGE function to point to local hard drive.
Allow Power Query to load in-cell images.

To download this workbook: https://www.mrexcel.com/youtube/mFd8HsHmfpA/

Table of Contents
(0:00) New Picture In Cell feature
(0:33) Pictures on drawing layer
(0:47) Inserting image in cell in Excel
(1:05) Fitting in Cell
(1:20) Alignment
(1:35) No apparent way to rotate image
(2:02) Use Case from Jerry
(3:48) Continue reading “Excel – Picture Place In Cell – Episode 2606” →

Leverage the Microsoft Fabric Trial

Posted on by Annie D

Did you know that Microsoft Fabric comes with a 60-day free Fabric Capacity trial? Adam shows you how to get it and the reason why you may not be able to use it.

Microsoft Fabric (Preview) trial
https://learn.microsoft.com/fabric/get-started/fabric-trial

📢 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/
— <a href="https://guyinacube.com" Continue reading “Leverage the Microsoft Fabric Trial” →

Why can’t I use Microsoft Fabric?

Posted on by Annie D

You’ve heard about all the great things with Microsoft Fabric, but you don’t see it in the portal. You only see the Power BI items and no persona switcher. What’s going on? Adam shows you to enable Fabric for your tenant.

Enable Microsoft Fabric for your organization
https://learn.microsoft.com/fabric/admin/fabric-switch

📢 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
— Continue reading “Why can’t I use Microsoft Fabric?” →