Exploring the Power Automate Visual in Power BI | Sending emails

Using Power Automate? Using Power BI? Why not put the two together for some interesting scenarios. Patrick uses the Power Automate visual, in a Power BI report, to send emails out.

Power Automate:
https://flow.microsoft.com/

Blog Announcement:
https://powerbi.microsoft.com/en-us/blog/announcing-the-new-power-automate-visual-for-power-bi-reports/

Documentation:
<a href="https://docs.microsoft.com/power-bi/create-reports/power-bi-automate-visual" Continue reading “Exploring the Power Automate Visual in Power BI | Sending emails”

Make your Power BI Visual POP with this column header trick

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”

Looking into the future of Power BI (2021)

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)”

Smart Narratives and Conditional Formatting in Power BI? Yes please!

Using Smart Narratives and you’d like to add some conditional formatting in Power BI? Patrick shows you some tricks to take Smart Narratives to the next level!

Download Sample: https://guyinacu.be/smartformattingsample

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

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

Want Continue reading “Smart Narratives and Conditional Formatting in Power BI? Yes please!”

How To Automate Sorting Columns Inside Power BI Using Tabular Editor

For today’s tutorial, Antriksh is going show how you can automate the process of sorting one column by another column inside Power BI or SQL server analysis services.

***** Video Details *****
00:00 Introduction
00:25 Dates table
02:50 Visual studio
03:20 Set reference to a Continue reading “How To Automate Sorting Columns Inside Power BI Using Tabular Editor”

Measuring RLS Performance in Power BI

Have you tried measuring performance of Row-Level Security (RLS) in Power BI? How much overhead does it have? That can be a challenge using the tools we talk about. Adam shows you how you can do it!

RLS Playlist:
rel=”nofollow”>https://www.youtube.com/playlist?list=PLv2BtOtLblH1dBK34FqClo2eXXQgWW1ui

RLS Course:
https://guyinacu.be/rlscourse

DAX Studio:
https://daxstudio.org

📢 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 – https://guyinacube.com/tools/

Intro: (0:00)
Static RLS: (0:50)
Dynamic RLS: (3:15)
XMLA Endpoint: (6:19)
Question?: (12:08)

#PowerBI #RLS #GuyInACube

Bringing Paginated into Power BI reports – INSANE AMAZING!

It’s here! Have a look at the Power BI Paginated visual for your Power BI Reports! It adds additional flexibility for displaying data as well as providing easy export options if that’s your jam.

Blog Announcement:
https://powerbi.microsoft.com/en-us/blog/paginated-report-visual-for-power-bi-reports-is-now-available-in-public-preview/

Documentation:
<a href="https://docs.microsoft.com/power-bi/visuals/paginated-report-visual" Continue reading “Bringing Paginated into Power BI reports – INSANE AMAZING!”

Fix my Calculation Group in Power BI

You’ve spent time creating Calculation Groups in Power BI only to find that they don’t work. What’s up with that? Patrick may be your only hope.

Calculation Groups Documentation:
https://docs.microsoft.com/analysis-services/tabular-models/calculation-groups

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

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

Want Continue reading “Fix my Calculation Group in Power BI”

Exploring the Visio visual in Power BI

Want to explore locations with data? The Visio visual in Power BI helps you do just that! Patrick looks at how to set it up and help use your data to highlight areas within a Visio diagram.

Download Sample: <a href="https://guyinacu.be/visiosample" Continue reading “Exploring the Visio visual in Power BI”

Refresh your data in Power BI WITHOUT a user???

Can a Power BI Dataset be setup to refresh without an actual user? It would be great from an automation perspective and to avoid being tied to someone specific. Adam digs in.

Service Principal Video:
https://www.youtube.com/watch?v=1SO19uik1rw

Add-DataGatewayClusterUser (DataGateway CMDLET – Continue reading “Refresh your data in Power BI WITHOUT a user???”