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?
Recently, I got a case where I need to show uploaded OneNote in Dynamics 365’s UCI in activity tab. In this blog we will discuss below two points: How to turn on OneNote Integration How to see uploaded OneNote in Dynamics 365 UCI Let’s start with first point: How to turn on OneNote Integration Go… Continue reading Show OneNote IN Dynamics 365 UCI
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()
Recently, we got a requirement which required us to easily allow a user to access their queue. After a descent amount of struggle, we finally found a way which would allow a user to see their queue without fumbling in the menu or advanced find option. So, here is what we did. Lets start. Open… Continue reading Provide easy access to a queue for current user
In our previous blog we have learnt embedding of Power BI tiles in PowerApps. Now, in this blog we’ll learn Charts in PowerApps. Charts are used for graphical representation of data. It can usually be read more quickly than the raw data. In PowerApps there are below types of charts: Column Chart – A column… Continue reading Charts in PowerApps
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
As the name suggests Page is any page of the Business Central and Inspection means careful examination of something. Hence, Page Inspection means closer examination of the Business Central Page. Page inspection allows you to get the details about a particular page you are on. It provides insight into the page design and elements that comprise the page along with the… Continue reading Page Inspection in Business Central
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
Recently, I got a case where I need to show a lookup field as dropdown in Canvas App and update its value in D365 Sales. I have searched a lot over the internet but failed. In my opinion, there is no handy material available for this problem at internet. So, after lots of struggle I… Continue reading Show LOOKUP field as dropdown in PowerApp & update value in D365 Sales
Edit: I would like to thank Ben Thompson for pointing out my mistake about licencing costs for Dynamics 365 Team member license. By now many of you are aware of how Microsoft has changed the Dynamics 365 Teams License. Microsoft now provides a dedicated app for users who hold this license. If a user has… Continue reading Dynamics 365 Teams License vs PowerApps Per Apps License
In the previous blogs i.e, Part – 1, Part – 2 and Part – 3 we had covered what is metadata, how to add new metadata in Web Form and Entity Form and it’s types i.e., Attribute, Notes, Section and Subgrid. Now, in this part we’ll discuss the remaining types and their properties. Below is the list:… Continue reading PowerApps Portal: Metadata and It’s Type Part – 4
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
In the previous blogs i.e., Part – 1 and Part – 2 we had covered what is metadata, how to add new metadata in Web Form and Entity Form and it’s types i.e., Attribute, Notes and Section. Now, in this part we’ll discuss ‘Subgrid’ and it’s properties. Subgrid Selecting ‘Type’ as ‘Subgrid’ allows us to… Continue reading PowerApps Portal: Metadata and It’s Type Part – 3
In the previous blog we had covered what is metadata, how to add new metadata in Web Form and Entity Form and also from it’s 6 types we had covered the very first type i.e., “Attribute”. Now, in this part we’ll discuss below types and their properties: Notes Section Let’s start with type “Notes”. NOTES… Continue reading PowerApps Portal: Metadata and it’s type – Part 2
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
The Web Form Metadata contains additional behavior modification logic to augment or override the functionality of form. It allows portal admin to further configure entity forms and web forms such as predefined values and enhancing fields. In this blog, we are going to cover the very first type of metadata property i.e., “Attribute” with it’s properties… Continue reading PowerApps Portal: Metadata and it’s type – Part 1
© All Rights Reserved. Inkey IT Solutions Pvt. Ltd. 2025
