Microsoft Power BI has gained immense popularity among the business intelligence tools category due to its features and leveraging the Microsoft Ecosystem and has been ranking at the first positions for multiple consecutive years in Gartner`s Magic Quadrant for Analytics and Business Intelligence Platform. Due to the increased popularity and its application in the Industry,…
A few years back when I was working on my first Power BI project for a large US life insurance client. I was working on a dataset with 40 million + rows and then faced issue in loading data into the Power BI Desktop. Due to large data in the Power BI Desktop, .pbix file…
Introduction In the dynamic realm of data analytics, Microsoft Power BI stands tall as a beacon of insights. For Mac users eager to harness this powerhouse for their analytical endeavors, the journey begins with a crucial question: How to download Microsoft Power BI on Mac OS/ Macbook? In this comprehensive guide, we unravel the intricacies,…
This article will show how to add measure in the slicer. Now the first question is why do we need to add a measure in the slicer? I got a situation where I have to roll up the granularity level and find the difference%, Difference bps, and bps range. To achieve it there are two…
Sparkline in Power BI has been a long-demanding feature in Power BI. I first heard about sparkline a few years back when I was attending corporate training on Tibco Spotfire. Sparkline is a tiny chart that helps to analyze the trend for each row as it is placed in each cell of the column in…
In this article, we will see step-by-step how to implement cross-report drill-through functionality. Cross Report Drill Through can be very useful when we want to reduce the size of each dataset which is extremely useful when there is a data size limitation based on license. Pre-Requisite for Cross Report functionality in Power BI While implementing…
While making a report in Power BI, it is always a important point of consideration to know different options to share report with the end users. Also, it is always of great interest for anyone to know how can a power bi report be shared with non- pro users. Let`s discuss it in this article….
Most of the developers working on Microsoft Power BI face issues in two ways. First, the Microsoft Power BI Application installed on the machine is not working properly and the developer is facing problems in performing any task. Second, the issue is related to report optimization. Generally, it is the responsibility of the developer to…
Earth Soft`s EQuIS is a environmental data management solution which is used by large number of companies and government/private agencies around the world to store and manage environmental chemistry, biology, geology, hydrology, limnology, air related data. Now, in the recent May 2021 Microsoft Power BI update, EQuIS connector has been provided in Power BI so…
Parquet file is a popular file format used for storing large, complex data. It is an open-source file format that is available in a project in the Hadoop ecosystem. Data is stored in the flat columnar format which is considered to be more efficient than row-based files such as CSV. Previously, We have to use …