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()
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… Continue reading Embedding PowerBI Tile in PowerApps
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… Continue reading PowerApps And PowerBI Integration
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… Continue reading Power BI > Embed Dashboard/Report in D365 Sales with RLS – 4
We discovered several approaches to embed Power BI Dashboard/Report in D365 Sales, but each approach came with certain pre-requisites or cons that might not complement our requirements. Blogs posted earlier regarding the other 2 approaches either need Power BI Pro License for each user or it doesn’t filter out data according to the users and… Continue reading Power BI > Embed Dashboard/Report in D365 Sales with RLS – 3
There are various approaches to share Power BI dashboard or report in D365 Sales and every approach has it’s own merits & demerits. Our previous blog describes an approach that doesn’t work if we need to restrict data from the users. I recommend you read through the previous blog first, to get the context. Now,… Continue reading Power BI > Embed Dashboard/Report in D365 Sales with RLS – 2
Microsoft Power BI enables its global users to share the Power BI dashboard or report by embedding them in various applications and sites. Likely, we can also share them in our D365 Sales using Publish to Web or Embed URL. There are many ways to achieve this, but not all approaches fulfill the requirement to… Continue reading Power BI > Embed Dashboard/Report in D365 Sales with RLS – 1
Power BI has advanced a lot since the last few years. We all know, that now, Power BI REST API provides service endpoints for various functionalities such as embedding, administration, interaction with report & user resources. While working on the scenario of maintaining different environments for Power BI reports such as “DEV”, “TEST” and “PROD”,… Continue reading Power BI > REST API – RebindReport issue
Nowadays, Power BI is used by many large organizations to collect information that helps their organization grow in the market. The increasing use of Power BI in such organizations, demands, mostly a development team that takes care of the reports’ development & deployment from A to Z. This demands the team to follow best practices… Continue reading Power BI > Development Cycle – DEV, TEST & PROD environments
We all know how the basic components in Power BI should work. But as soon as you think that now you have reached the stage where you know almost all about Power BI, it leaves you open-mouthed. Recently, I came across a very weird issue – “A BLANK row getting added to the Table from nowhere”… Continue reading Power BI > The magical BLANK row in table
Power BI provides several different ways to fetch data from Dynamics 365 CE and today I will share my know-how on them. 1. Dynamics 365 Online Connector This method is mostly used to fetch data from Dynamics 365 CE. Initially, this was the only method to fetch data from CE. To use this, go to Get… Continue reading Power BI > How to fetch Dynamics 365 CE data
Hello DAX-sters! We have already created a report where we can choose what data we can show – dynamically. You can refer to the blog here. How about we get the freedom to choose even how the data can be shown, i.e. weekly, monthly, quarterly, or yearly? Every so often we need the availability of… Continue reading Power BI > Dynamic Scales & Values
Many of us often face difficulties understanding the dataset size limits in different scenarios and different capacities. So, here is a quick understanding of the same. Different type of capacities: 1. Shared Capacity 2. Premium Capacity 3. Azure Power BI Embedded Capacity Power BI provides either Shared Capacity or Premium Capacity. Power BI, by default,… Continue reading Power BI > Size limits to consider while choosing the right capacity
Power BI has been growing day by day with the new features that the Power BI team is bringing every month. One of the great features for those who are working with Sharepoint Online is that we can use “Sharepoint Online” List as a data source in Power BI to get an overview about Sharepoint… Continue reading Power BI > Sharepoint Online List as Data Source
© All Rights Reserved. Inkey IT Solutions Pvt. Ltd. 2025
