Posts

Showing posts from October, 2021

Automatically Install Apps

  https://powerbi.microsoft.com/en-us/blog/automatically-install-apps/

Why does Microsoft Teams create a Power BI workspace???

https://www.youtube.com/watch?v=J3FD_4Uset8  

Integrate Power BI reports in Microsoft Teams

https://www.youtube.com/watch?v=YWoRoiMFIxQ  

Bring Power BI to your every day Microsoft Teams usage

  https://www.youtube.com/watch?v=UbuGmVIOmp4

Use Azure B2B to invite external users to view Power BI content

  https://www.youtube.com/watch?v=xxQWEQ1NnlY

Share Power BI reports and apps with external guests for free - Azure B2B

  https://www.youtube.com/watch?v=Mm-902ry-qU

Security in Power BI

Official documentation for Row-Level security with Power BI https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls Row-Level Security with Power BI Embedded https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-row-level-security Row-Level Security Guidance in Power BI Desktop https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance USERPRINCIPALNAME() https://dax.guide/userprincipalname/ Power BI Security Whitepaper https://docs.microsoft.com/en-us/power-bi/admin/service-admin-power-bi-security

Role- Based Security in Power BI Service

 RLS generally only works with people/groups that are Viewers. With Many-to-Many implementation of RLS, you need to select Cross filter direction Both and click the checkbox Apply security filter in bot directions.

Role-Based Security in Power BI Desktop

 Power BI Desktop has Manage roles and View as in the Security section of the Modeling ribbon.

Error Connecting to Tabular Model in Excel

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2498739e-46ba-4d2a-adb3-a98183e8fa94/can-connect-to-my-azure-tabular-model-in-power-bi-but-not-excel?forum=sqlanalysisservices   PowerBI uses the ADOMD provider (which is included in the PowerBI install).  Excel uses the MSOLAP provider installed on your machine. So you could try downloading and installing the latest MSOLAP provider from here: https://docs.microsoft.com/en-us/analysis-services/client-libraries?view=azure-analysis-services-current   Also Power BI has Analyze in Excel which will provide the download.

Trace Excel Power Pivot using DAX Studio

  https://www.youtube.com/watch?v=Ao4ov36slic

Column Profiling in Power BI Desktop

  https://www.youtube.com/watch?v=WN1cvJGutT8

Power BI Feature Spotlight: Using Bookmarks to Create Pop-Up Windows

  https://www.youtube.com/watch?v=87eoEjrF9jQ

Dax Studio Documentation

https://daxstudio.org/documentation/videos/index.html