You have published your Power BI report and want to share it with others. Now you see that you can share it through basic sharing, workspaces, Apps, publishing to web, Power BI embedded, and SharePoint online. The wide range of this variety of methods for sharing makes it confusing to choose the suitable method. I Read more about Power BI Sharing Methods Comparison – All in One Review[…]
There is a method of sharing the Power BI content called Secure Embed Code. This method of sharing is as simple as Publish to web to implement, but it doesn’t have the security issues of that method. Through this method, you can securely publish Power BI reports through a custom web portal or application with Read more about Sharing Power BI Reports with Secure Embed code[…]
In the last two articles, you have learned what is Dataflow and sample use case scenarios of that in Power BI, and also you learn how to create a dataflow. Before going any further in the dataflow discussion, we have to make a quick pause and talk about the Common Data Model (CDM). Dataflow integration Read more about What is the Common Data Model and Why Should I Care? Part 3 of Dataflow Series in Power BI[…]
In the previous post, you’ve learned what Power BI Desktop is, and how it can be used for getting data and also doing visualization. We used the Pubs sample dataset for that example. In this post, we continue the same example, with a touch on modeling and also more visualization. This post is part of Read more about Power BI Desktop; Getting Started – Part 2[…]
Aggregations are speeding up the model. However, the aggregated table is not just one table; It can be multiple layers of aggregations. Aggregation by Date, aggregation by Date and Product, aggregation by Date and Product and Customer. Multiple layers ensure that you always have the best performance result possible, and you only query the DirectQuery Read more about Multiple Layers of Aggregations in Power BI; Model Responds Even Faster[…]
An aggregated table can be a layer on the source DirectQuery table. This table needs to have a proper relationship set up with other tables and also the proper storage mode configuration. Storage Mode configuration of the composite model is an important configuration and critical part of setting up the aggregation. The storage mode configuration Read more about Dual Storage Mode; The Most Important Configuration for Aggregations! Step 2 Power BI Aggregations[…]
Aggregation tables are the fast-performing solution for huge DirectQuery tables in Power BI. In the previous blog post, I explained what aggregation is and why it is an important part of a Power BI implementation. Aggregations are part of the Composite model in Power BI. Your first step for the aggregation set up is creating Read more about Power BI Aggregation: Step 1 Create the Aggregated Table[…]
To build a robust BI system, you need to cater for errors and handle errors carefully. If you build a reporting solution that the refresh of that fails everytime an error occurs, it is not a robust system. Errors can happen by many reasons, In this post, I’ll show you a way to catch potential Read more about Exception Reporting in Power BI: Catch the Error Rows in Power Query[…]
You read it right, you don’t have to write DAX. If you are calculating a year to date, running total, or every rolling average, you may be able to do it without writing a single line of DAX code. How this is possible? With Quick Measures. Quick measures are an easy way to create DAX Read more about Quick Measures in Power BI: You don’t have to write DAX!?[…]
Sum and Sumx are functions that often founded to be misleading for many Power BI users. As both functions are doing the aggregation, it seems a bit confusing what is the actual difference between these two. There are many blog posts and articles about each function. I always explain the difference with simple demos in Read more about SUM vs SUMX; What is the Difference of the two DAX Functions in Power BI?[…]