Tag: Power BI
Updating the SQL DataSource from Power BI using Power Automate Visual
Inkey, August 6, 20217030 Views
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 […]
Read moreCalculation Groups in Tabular Editor
Inkey, June 11, 20214562 Views
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 […]
Read morePower BI > Embed Dashboard/Report in D365 Sales with RLS – 5
Inkey, April 30, 20215040 Views
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 […]
Read morePower BI > Get Data from OneDrive for Business (Folder as a source)
Inkey, March 12, 202136733 Views
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 […]
Read morePower BI > How to easily copy Measures from one pbix file to another?
Inkey, February 5, 202146910 Views
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 […]
Read morePower BI > USERELATIONSHIP Vs. CROSSFILTER
Inkey, January 21, 202112762 Views
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 […]
Read morePower BI > How to make PBI Reports pointing to deleted Power BI Dataset working again?
Inkey, November 26, 20206035 Views
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 […]
Read morePower BI > How to handle multiple time zones?
Inkey, September 18, 20207424 Views
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 […]
Read morePower BI > How to efficiently change the column names?
Inkey, September 11, 20205984 Views
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 […]
Read morePower BI > Use of ISINSCOPE()
Inkey, August 28, 20208782 Views
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 […]
Read more
