What Do You Need to Implement Dynamic Row-Level Security in Power BI?

Reza Rad explains what you need to implement a dynamic RLS.

Watch and Win! Centralize Backups for Scattered Data — Without License Fees

Data is scattered across platforms – PCs, VMs, cloud apps. See how Active Backup centralizes data protection in one place. Plus, enter to win a Synology NAS!

Limit the Amount of Data You Work With in Power BI Desktop Using Parameters and Deployment Pipelines

Wouldn’t it be great if there was a way to work with a small subset of your data in Power BI Desktop and then, after you publish, load all the data when you refresh? The good news is that this is now possible with the new deployment pipelines feature in Power BI! Chris Webb gives a simple example of how to do this.

Refreshing a Power BI Dataset in Azure Data Factory 

Meagan Longoria gives a step-by-step explanation of how to use Data Factory to refresh a Power BI dataset.

3 Building Blocks of Machine Learning You Should Know as a Data Scientist

What are the key building blocks that make up a successful machine learning system? Pranav Dar gives you an overview of these different components in a machine learning or AI system—plus read about an example of a self-driving car.

Top 5 Best Practices for Data Collection and Storage in Microsoft Excel

Paul Stevenson shares 5 tips for using Excel to collect and store research data that can save you a lot of headache when importing data from .xlsx files into R for analysis.

Easy Looping in Power BI/Power Query

In this video, Parker Stevens explains how to iterate over data in Power Query. This is an advanced technique that allows you to loop through function calls to produce the desired result. This specific technique creates a While or Do While loop, and you can also create a For loop if desired.

How Data Visualization Can Help with Income Inequality

When it comes to using data for social responsibility, one of the most effective ways of dispensing information is through data visualization. The process involves putting together data and presenting it in a form that is more easily comprehensible for the viewer.

Upcoming Virtual Events

Data Univariate Forecast Engine - Yasmin Bokobza

Sunday, August 02. 14:00 UTC.

Machine Learning in Power BI - Alex Whittles

Tuesday, August 04. 18:00 UTC.


We are recruiting community contributors for all PASS Insights newsletter editions:

DBA, BI, Developer, and Analyst.
We’re looking for engaging, in-depth, and technically-focused ideas to feature each month. If you are interested, submit your ideas to insights@pass.org.
You just might see yourself featured in an upcoming edition!

Looking for more than just Analyst educational and technical content?
Log in to your PASS account and subscribe to the new BI, DBA, and Developer PASS Insights newsletters.