Create Hybrid Tables with Tabular Editor for Power BI? YES!!!

Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can do just that in Tabular Editor!

–This Year
let
Source Continue reading “Create Hybrid Tables with Tabular Editor for Power BI? YES!!!”

Excel – Find The Date Of The First Sale In Each Month – 2470

Gagan has sales for three years. For each month in those three years, what is the first date that had a sale? For some reason, Gagan needs to do this without a helper column.

My first solution is a pivot table Continue reading “Excel – Find The Date Of The First Sale In Each Month – 2470”

REPLAY Power BI tips from the Pros – LIVE (Feb 26, 2022)

Join us live as we answer your questions about Power BI!

💥 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 Continue reading “REPLAY Power BI tips from the Pros – LIVE (Feb 26, 2022)”

Make your Power BI mobile reports POP

You wanted better control over your Power BI Mobile Report layouts? Look no further. Michal Heldy joins us to walk us through how to get the most out of this new enhancement in Power BI Desktop!

Connect with Michal Foster Heldy
<a Continue reading “Make your Power BI mobile reports POP”

REPLAY Power BI tips from the Pros – LIVE (Feb 19, 2022)

Join us live as we answer your questions about Power BI!

💥 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 Continue reading “REPLAY Power BI tips from the Pros – LIVE (Feb 19, 2022)”

Do we need more Power BI Premium Capacity?

Capacity planning for Power BI Premium is not an exact science. How much capacity do you need? As with most things, it depends! Adam walks through some things to consider when thinking about your planning.

Premium Gen2 capacity load evaluation
<a href="https://docs.microsoft.com/power-bi/admin/service-premium-concepts" Continue reading “Do we need more Power BI Premium Capacity?”

A little trick for SharePoint Online Images in Power BI

Using secure images in Power BI reports can be a pain! Patrick has a little trick for you to using images from SharePoint Online though. Check this out!

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

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

Want to take your Power Continue reading “A little trick for SharePoint Online Images in Power BI”

Excel STOCKHISTORY Never Falls On Weekend Or Holiday – 2468

TKH is using the new STOCKHISTORY function in Excel. He is looking for stock prices from 7, 14, 30, and 60 days ago. When you are asking for a single day, the STOCKHISTORY function returns a #VALUE error if the Continue reading “Excel STOCKHISTORY Never Falls On Weekend Or Holiday – 2468”

Excel Doing Billions Of Calculations To Study Wordle

After my previous video showing AROSE as the best first guess in Wordle, I started doing some more cool Excel formulas to test all Wordle words. This is a long video for the weekend, mostly of me geeking out about Continue reading “Excel Doing Billions Of Calculations To Study Wordle”

REPLAY Power BI tips from the Pros – LIVE (Feb 12, 2022)

Join us live as we answer your questions about Power BI!

💥 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 Continue reading “REPLAY Power BI tips from the Pros – LIVE (Feb 12, 2022)”

How to get Secure Images in Power BI Reports

Struggling getting images in your Power BI Report? Don’t want to use anonymous URLs for the image? Patrick walks you through an approach to use secured images in your reports!

Show “secured” Images in Power BI
https://pbi-guy.com/2021/11/17/show-secured-images-in-power-bi/

📢 Become a Continue reading “How to get Secure Images in Power BI Reports”

How do I get my Excel users to use Power BI???

Lots of people use Excel and love it! But what about Power BI? Why not use both together? Patrick looks at how Excel users can take advantage of Power BI and may just start using that!

Start in Excel to connect Continue reading “How do I get my Excel users to use Power BI???”