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[…]
These days, Dataflow (Power Query in Power BI Service) is a new feature that has been released. according to[1]: Dataflow is a Power Query process that runs in the cloud independently from any Power BI reports. If you want to know more about dataflow see [1] There is a new feature in dataflow that Read more about AI in Dataflow, Power BI webservice, Cognitive Service -Part1[…]
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[…]
With getting 2018 wrapped up, I would like to thank you all for visiting our blogs and giving us your most valuable feedback. Here in this post, I’ll point out some of the most viewed articles we have shared and links to our books. 2018 was a year for me that I did moderate on writing Read more about Top 10 RADACAD Blog Posts of 2018[…]
In this series, I am going to show how to create an application that able to detect a face in a picture and able to identify the age, gender, emotion, hair color and so forth for each person in a picture using Microsoft Power Apps, Microsoft Flow and Cognitive Service. In the first Part, I Read more about Create Power Apps for taking photo- Part 1- Face Recognition by Power Apss, Microsoft Flow and Cognitive Service[…]
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[…]
Aggregation can speed up the performance of DirectQuery sourced tables significantly. To use it, firstly, you need to create an aggregation table. Secondly, you must set up proper storage modes for tables in the model. Finally, you have to configure the aggregation functions, which I will explain in this post. You can learn about aggregation Read more about Power BI Aggregations Step 3: Configure Aggregation Functions and Test Aggregations in Action[…]
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[…]
All source files for this article can be downloaded here : A good friend and member of my local Power BI User Group contacted me recently to ask if I might help with a problem he trying to solve in DAX. He was keen to track the value of items purchased over time in chronological Read more about DAX : Inventory or Stock Valuation using FIFO[…]