Category: Power BI
Power BI > Get Data from OneDrive for Business (Folder as a source)
Inkey, March 12, 202136818 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, 202146941 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, 202112788 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, 20206051 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, 20207436 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, 20205995 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, 20208796 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 moreEmbedding PowerBI Tile in PowerApps
Inkey, August 8, 20205238 Views
In our previous blog we have learnt embedding of PowerApps in Power BI report. Now, in this blog we’ll learn to embed PowerBI tiles in PowerApps. Let’s look at the steps required to add Power BI tiles in Power Apps. In PowerApps click on Insert tab. Click on Charts and then select Power BI tile […]
Read morePowerApps And PowerBI Integration
Inkey, July 10, 20203145 Views
Lets check out integration of PowerApps and Power BI in this blog. PowerApps and Power BI are pretty awesome tools by themselves. By combining them, we can potentially, achieve a lot more. By putting the PowerApp within the Power BI itself, we can give the user the ability to put in the data that he […]
Read morePower BI > Embed Dashboard/Report in D365 Sales with RLS – 4
Inkey, June 5, 20202771 Views
As there are various approaches to embed Power BI Dashboard/Report in D365 Sales, we might often use a different approach to achieve it only to realize that it doesn’t suit our cost or requirements. We have posted blogs describing the other 3 approaches but they have their own limitations regarding licenses or restriction of data […]
Read more
