Streamline Power BI Refresh: Refresh dataset after a successful refresh of dataflow

Do you have a Power BI dataset that gets data from a dataflow? have you ever thought; “can I get the dataset refreshed only after the refresh of dataflow completed and was successful?” The answer to this question is yes, you can. One of the recent updates from the data integration team of Power BI Read more about Streamline Power BI Refresh: Refresh dataset after a successful refresh of dataflow[…]

Power BI Dataflow vs Data Warehouse: Which one to choose?

Dataflow is the data transformation service in Power BI, and also some other Power Platform services. Data Warehouse is the cloud storage and also compute engine for data. I often get this question that: “Now that we have dataflow in Power BI, should we not use the Data warehouse? What are the differences? which is Read more about Power BI Dataflow vs Data Warehouse: Which one to choose?[…]

Power BI User Access Levels: Build and Edit are different

Often I have seen Power BI users have access to the areas that they shouldn’t. In Power BI, you can share a report with a user just for view only, or give them access to view and built, or to Edit. These are all different levels of access. Build access is the one that is Read more about Power BI User Access Levels: Build and Edit are different[…]

Row-Level Security on a DirectQuery to Power BI dataset composite model: My Findings

With the DirectQuery to Power BI or Azure analysis services dataset, there are some limitations on the way that RLS (Row-level security) works. Considering that I have written a book and many blogs on this subject, It was fair to have a look at how this works. In this blog and video, you will learn Read more about Row-Level Security on a DirectQuery to Power BI dataset composite model: My Findings[…]

DirectQuery for Power BI dataset: How does it work?

In my previous article and video, I explained why DirectQuery for a Power BI dataset is an important feature. In this blog and video, I explain how this feature works step by step. Prerequisite Before understanding how this feature works, I recommend reading below to understand WHY this is a game-changing important feature: Not from Read more about DirectQuery for Power BI dataset: How does it work?[…]

Power BI Salary Survey and Report 2021

Are you underpaid? or you are getting paid in the market range? If you are looking for a job, what range of salary you should be looking for? The Salary survey and the report is helpful to answer these questions. A salary survey is a form that everyone fills, and from the result of that, Read more about Power BI Salary Survey and Report 2021[…]

Power BI Helper Version 11 Feature Summary

At the end of the year 2020, we have a gift for you. Version 11 of Power BI helper has some amazing new features as below; Documentation Customization of the style Customization of the items to be exported Formatting DAX expressions in the document List of all visuals for every page Showing the measure dependency Read more about Power BI Helper Version 11 Feature Summary[…]

DirectQuery for Power BI datasets and Analysis Services. The composite model with Analysis Services. What is it and why it is a big deal?

The news of the latest update of Power BI Desktop, December 2020, is now everywhere. Especially the most exciting feature of all is the DirectQuery for Power BI datasets and analysis service, or in other terms composite model for Power BI datasets. However, you might ask, what that mean? what is it? and how it Read more about DirectQuery for Power BI datasets and Analysis Services. The composite model with Analysis Services. What is it and why it is a big deal?[…]

The importance of knowing different types of Power BI users; a governance approach

Power BI users are not all in the same category. If you treat everyone the same, then you wouldn’t have a successful Power BI adoption. You would likely spend too much on the training and gain much less of adoption. In this article, I’ll explain what are the different types of users and what are Read more about The importance of knowing different types of Power BI users; a governance approach[…]

Clean Power BI model with a few clicks – Power BI Helper Version 10 Feature Summary

The most exciting feature of this version is that now with a few clicks you can clean up the Power BI model, but we have a few other things to add also; Exporting the result of DMV Partitions (Includes the M script of each table) Showing unused measures in the visualization tab showing all columns/measures Read more about Clean Power BI model with a few clicks – Power BI Helper Version 10 Feature Summary[…]