In our previous blog post, we delved into Power BI Projects and Git integration, catering to the needs of developers with Pro Capacity. Today, we venture further into the fascinating world of Power BI Deployment Pipelines. Our focus is on providing you with insights into how to seamlessly handle content within your development lifecycle. Unveiling… Continue reading Part 2: Streamlining Power BI Deployment Pipelines
In a much-anticipated move, Microsoft has unveiled Git Integration in Power BI for developers who work with Power BI Desktop Projects. This ground-breaking feature which is in preview, promises to revolutionize the way developers streamline development, source control, and collaboration within their Power BI projects. In this technical blog, we’ll delve into the intricacies of… Continue reading Part 1: Git Integration with Power BI
Consumerism is at an all-time high, especially after the economic lull in 2020. Since 2021, e-commerce sales have grown exponentially, to the point that in 2024 we are looking at a forecasted 6.2 trillion US dollars in e-commerce sales. This puts pressure on retail companies to optimize their data collection and analytics to respond to… Continue reading The Benefits of Power BI for Decision-Making
In today’s business landscape, organizations are constantly seeking ways to maximize growth while minimizing operational costs. Sharing essential information and insights with management or higher-level teams is crucial for decision-making. However, investing in Pro user or Premium per-user licenses for a limited number of users who only need access to view a specific Power BI… Continue reading Efficiently Sharing and Synchronizing Power BI Reports within Your Organization: A Cost-effective Approach
Imagine going to groceries and being forced by your mother to negotiate the best price for a variety of things from different vendors; it sounds tiresome, doesn’t it? What is the easier way to resolve this? You will visit a supermarket, where you can simply find everything you need under one roof. Data professionals face… Continue reading Microsoft Fabric – The One-Stop Shopping Mall
Mining is one of the most essential and possibly one of the oldest industries in the world. In ancient times, people started mining metals to make tools. With the discovery of coal, coal mining started followed by the discovery and mining of oil. Almost everything that we get which forms the very basic foundation stone… Continue reading Mining Industry… to the cloud!
In the earlier blog post, we stated how to identify referenced measures or columns, i.e. whether they are used in other measures or not. If you haven’t visited the blog post, please click here. It is a very useful blog, especially in the big Power BI models. But this won’t be helpful when we would… Continue reading Power BI > How to identify referenced Measures and Columns in Model – II
Most of the time, while updating the existing model, it’s hard to identify which measures or columns are being used in report visualization and which are referring to other measures or columns. Many times, while developing a report, there are frequent changes in the requirements and we need to modify/update the data model accordingly, which… Continue reading Power BI > How to identify referenced Measures and Columns in Model – I
We can now embed Power BI Dashboard/Reports in PowerApps Portal with few easy steps. Prerequisite:- D365 Customer Service organization having a Global user with D365 and Power BI license. ENABLE POWER BI VISUALIZATION In the PowerApps select the environment where you have provisioned the Portal. Go to Your Apps section from Power Apps home page and locate… Continue reading Embed Power BI reports in Power Apps Portal
Power BI supports up to 32766 characters of data in a column of TEXT Data Type. What if we have more data stored in the data source? Recently, we came across a requirement where we had to show the content of an email in HTML format in the Power BI report. The report was built… Continue reading Power BI > How to deal with a Text column having a length of more than 32766 characters.
Ever thought of manipulating the data in your SQL data source directly from the Power BI Report? If yes, our prayers have been heard (as the use of Power Automate within Power BI is still in Preview as of writing this blog) and will be answered soon (when made GA)! An exciting new feature was… Continue reading Updating the SQL DataSource from Power BI using Power Automate Visual
Consider a scenario where your measure’s definitions are the same but the only difference is the base measures. For example, while doing time-related calculations like MTD, YTD, QTD for 3 different calculations/measures, we need to create 3 measures for MTD, 3 measures for YTD, and 3 measures for QTD, resulting in total 9 measures such… Continue reading Calculation Groups in Tabular Editor
There are various approaches to embed Power BI Dashboard/Report in D365 Sales, but each approach comes with its own drawbacks and cons that might not complement your requirements. Earlier we have posted blogs that describe the 4 approaches but as I said they have their own pre-requisite and cons. With the advancements of Power BI… Continue reading Power BI > Embed Dashboard/Report in D365 Sales with RLS – 5
Microsoft Power BI supports many data sources from where we can fetch data and a good Microsoft Power BI Consulting services provider can help, but many times, we need to use some workaround to fetch data from certain data sources. One such case is to get data from a folder on OneDrive. There are no… Continue reading Power BI > Get Data from OneDrive for Business (Folder as a source)
Have you ever questioned if it is feasible to move all of the measures from one Power BI PBIX file to any other PBIX file? Imagine you’ve got 2 PBIX files with the same models, i.e all tables used in the measures have the same data structure. If someday you are in this position then… Continue reading Power BI > How to easily copy Measures from one pbix file to another?
Power BI has different DAX functions using which we can have our results in many different ways. As far as the result is concerned, it doesn’t matter which road we take to reach the destination but, we would always strive to get the most optimal solution. We often need bi-directional relationships to let the filters… Continue reading Power BI > USERELATIONSHIP Vs. CROSSFILTER
Recently, we had come across an issue which we thought is very common and is easily resolvable. But, we were highly mistaken. We had several reports which were using a shared Power BI Dataset. We accidentally deleted the dataset on Power BI Service. Naturally, it deleted all the other reports pointing to this dataset. The… Continue reading Power BI > How to make PBI Reports pointing to deleted Power BI Dataset working again?
We have often encountered requirements that need the date and time columns to change according to the timezones of the user. Conversion according to the timezone requires to add/subtract the offset hours to the DateTime field in UTC. As this is something that is not available in Power BI out-of-box, we have found an approach… Continue reading Power BI > How to handle multiple time zones?
While preparing our Data Model, we are often tasked to change the column names of the tables which are brought into Power BI using GetData. It is very time consuming if we change the names of each column of all the tables manually but it is equally important. The time & efforts seem futile when… Continue reading Power BI > How to efficiently change the column names?
Power BI has advanced incredibly in the last few years. Microsoft has been working their fingers to the bone to make Power BI simple to use and easily adaptable. But at times, it gives us hard time to achieve even the simplest of requirements, or at least we think so. Recently, I faced one such… Continue reading Power BI > Use of ISINSCOPE()
© All Rights Reserved. Inkey IT Solutions Pvt. Ltd. 2025
