There are some updates for Power BI Premium Gen2 you should know about! Adam talks about the upcoming migration date and more! Are you ready for Gen2?
Plan your transition to Power BI Premium Gen2
https://docs.microsoft.com/power-bi/admin/service-premium-transition-gen1-to-gen2
Install the Gen2 metrics Continue reading “Power BI Premium Gen2 updates (January 2022)”
I know of nine ways in Excel to Paste Values.
One of these is about to be wiped out by Microsoft and the Excel team.
I think all nine of them are important!
Here are the nine ways that I know of to Continue reading “Urgent Need To Protect Paste Values! Survey: How Do YOU Paste Values”
The F4 key in Excel has a dual life. Most people know F4 as the way to put dollar signs in a formula reference. But when you are not editing a formula, F4 will repeat the last command.
Some of you Continue reading “The F4 Key To Repeat Is My Favorite Excel Shortcut – 2460”
An update on video 2458. There is a setting about how Excel interprets a two-digit year. Microsoft changed this setting from 2029 to 2049. But Excel refuses to accept the 2049 setting. Unless you change the setting in Control Continue reading “The Two Digit Year Setting Does Not Work If You Never Change It – 2458B”
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 (Jan 15, 2022)”
Tired of having to wait for the next refresh to see current data in your Power BI Report? Hybrid Tables is here to help you! Patrick looks at how you can use this feature to have an imported table that Continue reading “Combining refresh and real time with Hybrid Tables in Power BI”
It is a little-known feature that you can automatically break the text in an Excel Textbox into multiple columns. Here is how to find the setting.
Have you checked out sparklines in Power BI? Patrick explores how to set them up and also how you can be creative with them to add additional context to your reports!
KPI Video:
https://www.youtube.com/watch?v=zHzSBNES6jE
📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Add a little info to your Sparkline in Power BI”
If you type a date with a two digit year, Excel treats anything up to 29 as being 2029. Once you get to 30, though, they assume you mean 1930. With 2030 only eight years away, it might be time Continue reading “Excel Fix 2029 Rule for 2-Digit Year – 2458”
The new release wave was published for Power BI! This is the roadmap for what is to come. Adam explores what it shows and what you can expect.
Microsoft Power Platform release plans
https://aka.ms/pbiroadmap
Power BI release plan report by Continue reading “Looking into the future of Power BI (2021)”
You enjoyed the intro to Python video, now let’s look at R Script within Power BI! There are a lot of similar aspects and Patrick walks you though what you should know to get started.
📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Intro to R with Power BI”
There are different ways to change column headers for a table or matrix visual in Power BI. Adam covers a few common ways and leave you with a trick to make the visual POP!
📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Make your Power BI Visual POP with this column header trick”