Struggling with understanding what is filtering your visual or Power BI report? Patrick walks you through how you can tell what is going on.
SQLBI Filter Context: https://www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take Continue reading “What’s this Power BI report filtered by???”
You may have struggled getting a whole row to highlight in a Power BI report. Patrick shows you how you could do this with a Paginated report easily.
Paginated Samples:
https://github.com/microsoft/Reporting-Services
📢 Become a member: https://guyinacu.be/membership
*******************
Want Continue reading “Highlight a row in a Power BI Paginated report”
We talk about optimizations a LOT! We pile onto a question posed by Chris Webb – Should you optimize for CPU in Power BI? We think the answer is YES! Let’s explain…
Chris Webb’s Blog:
https://blog.crossjoin.co.uk/2021/09/19/why-you-should-optimise-your-power-bi-premium-reports-and-refreshes-for-cpu-time-as-well-as-duration/
3 signs it’s time Continue reading “When optimizing Power BI don’t forgot about CPU”
Have you struggled with using Row-Level Security (RLS) on a dimension connected to two fact tables? Patrick looks at some options you can use to accomplish this in Power BI.
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take Continue reading “RLS with TWO Fact tables in Power BI”
Need to configure Incremental Refresh but don’t have access to the Power BI Desktop file? No problem! Patrick shows you how to set things up with Tabular Editor.
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power Continue reading “Configure Incremental Refresh with Tabular Editor”
You should be reviewing performance of your Power BI Reports. This report from Smart Power BI helps you to visualize the results of Performance Analyzer. Let’s check it out!
Performance Analyzer Documentation:
https://docs.microsoft.com/power-bi/create-reports/desktop-performance-analyzer
ADVANCED POWER BI PERFORMANCE ANALYSER BY SMARTPOWERBI
<a Continue reading “Review Performance Analyzer in this Power BI Report from Smart Power BI”
Calculating Days since a given date in DAX is pretty straight forward. But, what if you want flexibility with different dates in your model? Patrick shows you how to do that with Power BI.
📢 Become a member: rel=”nofollow”>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 – https://guyinacube.com/tools/
#PowerBI #DAX #GuyInACube
Do you analyze performance of your Power BI report? You SHOULD! Why the heck does Adam start with a blank page? Find out in this video!
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills Continue reading “Page intentionally left blank”
Wondering how Patrick created a popup video in a previous video? Well, here you go! Learn how you can create a popup experience to provide more information in your Power BI report.
Bookmarks Playlist:
https://www.youtube.com/playlist?list=PLv2BtOtLblH1IJqcqSuMTyvEi7W-laWti
📢 Become a member: <a Continue reading “Create a Popup Window in Power BI”
Custom visuals can really expand the capabilities of Power BI! Some organizations want the ability to control what is used within their tenant though. Find out how to govern customer visuals in this video!
📢 Become a member: rel=”nofollow”>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 – https://guyinacube.com/tools/
#PowerBI #CustomVisuals #GuyInACube
Not sure what a REST API is? Or what you can do with them in Power BI? Find out how you can easily take advantage of them without having to write a bunch of code. Use PowerShell instead!
REST API Reference Continue reading “Call any Power BI REST API with PowerShell”
Tired of all those buttons for navigation in your Power BI reports? Patrick shows you how to use the Page Navigator to easily get going and get rid of all those buttons!
📢 Become a member: https://guyinacu.be/membership
*******************
Want Continue reading “Use Page Navigator to go to the NEXT LEVEL in Power BI”