Category: Power Query

Row-Level Security and Object-Level Security together in Power BI??? Yup!

Posted on by Annie D

Struggling with using Row-Level Security (RLS) together with Object-Level Security (OLS) in Power BI? You think it can’t be done? Think again! Patrick shows you how to use both together.

Announcement Blog: https://powerbi.microsoft.com/blog/object-level-security-ols-is-now-generally-available-in-power-bi-premium-and-pro/

Analysis Services Doc: https://docs.microsoft.com/analysis-services/tabular-models/object-level-security

FourMoo: https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-power-bi/

📢 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
— Continue reading “Row-Level Security and Object-Level Security together in Power BI??? Yup!” →

Who doesn’t like FREE Power BI training??? (2022)

Posted on by Annie D

There are a lot of free Power BI training options out there for business analysts and there is now training beyond that for your organization. Adam explores the latest free options that Microsoft has to grow and learn Power BI!

Matthew’s Blog: https://ssbipolar.com/2021/06/07/free-power-bi-intro-training-from-microsoft/

Microsoft Stores Power BI Intro Training: https://www.microsoft.com/store/workshops-training-and-events/professionals#keyword=Power%20BI

Instructor Led Training: https://aka.ms/pbitraining

Power BI Learn Content: https://docs.microsoft.com/learn/powerplatform/power-bi

Guidance Documentation: https://docs.microsoft.com/power-bi/guidance/overview

Adoption Roadmap: https://docs.microsoft.com/power-bi/guidance/powerbi-adoption-roadmap-overview

Implementation Planning: https://docs.microsoft.com/power-bi/guidance/powerbi-implementation-planning-introduction

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

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

Want to take your Power BI skills to the next Continue reading “Who doesn’t like FREE Power BI training??? (2022)” →

REPLAY Power BI tips from the Pros – LIVE (April 23, 2022)

Posted on by Annie D

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

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

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “REPLAY Power BI tips from the Pros – LIVE (April 23, 2022)” →

Demystifying Custom Partitions in Power BI

Posted on by Annie D

We talk about Incremental Refresh a lot, but what if you need custom partitions in Power BI? How do you even create those? They look scary! Patrick takes the mystery away and walks you through how you can create them.

Partitions in tabular models
https://docs.microsoft.com/analysis-services/tabular-models/partitions-ssas-tabular

📢 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
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #Partitions #GuyInACube

Excel Can You Merge Cells In A Table – 2483

Posted on by Annie D

Uncle S is trying to have a formula copy to new rows. So a table seems like a great way. But he also has merged cells and the table unmerges those.

In this video, two surprising Table tricks:
First, a table can contain Center Across Selection, which is better than Merging Cells in Excel.
Second, a surprising discovery from the Excelforo channel about new headings in a table.

Table of Contents
(0:00) Auto-copying formulas to new rows in Excel
(2:31) Can a table have a merged cell
(4:00) New table columns using custom lists in Excel

Blown AWAY by Column From Examples in Power Query

Posted on by Annie D

Column From Examples, in Power Query, keeps blowing our mind! Patrick shows you an example where he wanted to extract some data. Will Column From Examples work? Of course, it will! Check this out!

Add a column from examples in Power BI Desktop
https://docs.microsoft.com/power-bi/create-reports/desktop-add-column-from-example

📢 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
— Continue reading “Blown AWAY by Column From Examples in Power Query” →

Excel Pivot Table Months Or Weekdays Are Alphabetical – 2482

Posted on by Annie D

You have a pivot table in Excel. The months and weekday names are appearing alphabetically instead of in calendar sequence. This happens when your pivot table is based on external data or the data model.
There are two solutions. This video prefers using the Custom Sort Order option. This takes 8 clicks to fix the months and 8 clicks to fix weekdays.
If your Pivot Table Slicers are in the wrong sequence, then you should use the Data Model setting to sort one column by another column.

REPLAY Power BI tips from the Pros – LIVE (April 16, 2022)

Posted on by Annie D

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

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

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “REPLAY Power BI tips from the Pros – LIVE (April 16, 2022)” →

How to get a DATE TABLE easily in Power BI

Posted on by Annie D

Do you use a central date table for your Power BI datasets? There is a LOT of POWER in having one. Adam shows you different ways to create one including a really simple easy option that’s BANANAS!

REDUCE Power BI dataset size by 60% with ONE CHECKBOX???
https://www.youtube.com/watch?v=RnDdDlozcdo

Bravo for Power BI
https://bravo.bi

📢 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
— <a href="http://twitter.com/awsaxton" Continue reading “How to get a DATE TABLE easily in Power BI” →

Are you backing up your Power BI Dataset???

Posted on by Annie D

While Power BI is a SaaS service, backing up your dataset is still important. What if something was accidently deleted? How do you recover it? Patrick shows you how you can get a backup / restore process in place so you can sleep at night.

Backup/Restore PowerShell Script: https://guyinacu.be/backuprestorescript

Backup and restore datasets with Power BI Premium
https://docs.microsoft.com/power-bi/enterprise/service-premium-backup-restore-dataset

Power BI Service Principals 101
https://www.youtube.com/watch?v=1SO19uik1rw

📢 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 Continue reading “Are you backing up your Power BI Dataset???” →

REPLAY Power BI tips from the Pros – LIVE (April 9, 2022)

Posted on by Annie D

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

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

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “REPLAY Power BI tips from the Pros – LIVE (April 9, 2022)” →