Logo
banner

Blogs

Power BI > How to handle multiple time zones?

, September 18, 202093 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 more

Power BI > How to efficiently change the column names?

, September 11, 2020187 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 more

Power BI > Use of ISINSCOPE()

, August 28, 2020725 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

Embedding PowerBI Tile in PowerApps

, August 8, 2020337 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 more

PowerApps And PowerBI Integration

, July 10, 20201238 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 more

Power BI > Embed Dashboard/Report in D365 Sales with RLS – 4

, June 5, 2020194 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

Power BI > Embed Dashboard/Report in D365 Sales with RLS – 3

, June 5, 2020158 Views

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 […]

Read more

Power BI > Embed Dashboard/Report in D365 Sales with RLS – 2

, June 5, 2020151 Views

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, […]

Read more

Power BI > Embed Dashboard/Report in D365 Sales with RLS – 1

, June 5, 2020424 Views

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 […]

Read more

Power BI > REST API – RebindReport issue

, May 22, 2020402 Views

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”, […]

Read more