Jan04
298 Views
7 minutes read

Dynamic Data Columns in Power BI – an Example of Creating a Table Transpose

We have often come across scenario where we need to shift the data based on some filtering criteria. So, we just need to eliminate [···]

Read More

Jan22
1564 Views
6 minutes read

How To Migrate Azure Information Protection Labels From Dev To Production Tenant Using PowerShell

The opening statements by presenters in most of the Enterprise Mobility & Security (EMS) related ignite sessions last year was, “The data is exploding [···]

Read More

Jul24
4472 Views
3 minutes read

Modifying SharePoint Modern Site Header Layout and Site Logo Using PnP PowerShell

In our recent project we get requirements to modify Header layout and Site logo of SharePoint modern site. Recently, modern site header layout customization [···]

Read More

Sep25
1524 Views
7 minutes read

Excel for BI Reporting and Publishing Through SharePoint – Part 3

In the previous two articles of this article series, I have explained about how to create an Excel-based BI report using the SharePoint List [···]

Read More

Sep11
5438 Views
4 minutes read

Power BI Reporting Options with Dynamics 365 for Finance and Operations

Power BI is an analytical tool using which one can explore data and quickly create reports and dashboards. This is a rich platform and [···]

Read More

Jul31
1541 Views
5 minutes read

Excel for BI Reporting and Publishing Through SharePoint – Part 2

In my previous article I have provided the instructions about how SharePoint list(s) can be imported into Excel using OData Feed option, and how [···]

Read More

Jul17
3576 Views
5 minutes read

Excel for BI Reporting and Publishing Through SharePoint – Part 1

In a typical SharePoint scenario, we build many small scalable custom applications where the SharePoint list(s) hold the data. One of the major challenge [···]

Read More

Apr17
1771 Views
5 minutes read

What is the real-world use of Unpivoting columns?

Unpivoting columns comes as part of the package when you are doing a tutorial on Power Query or Power BI. I’m sure, many (like [···]

Read More

Mar13
9531 Views
3 minutes read

How to Use Aggregate Functions with Multiple Tables in Power BI

If you’ve been following my blogs, you’d be half expecting this ‘complexity’ that I mentioned in my last blog. However, for those you haven’t [···]

Read More

Dec26
2717 Views
9 minutes read

How to use Power BI in the context of SharePoint?

Who should use PowerBI? Anyone who knows the pain of presenting data in the form of charts/graphs, with added complexity of dynamic filters. However, [···]

Read More

Apr04
2734 Views
13 minutes read

Dynamics CRM Content Pack for Power BI

Part 1: Embedding Content Pack in Web Page The Microsoft Dynamics CRM content packs for Power BI allow you to easily visualize data in [···]

Read More

Mar01
2491 Views
3 minutes read

Four Reasons to Deploy Microsoft Power BI in Your Enterprise

You may recall a recent blog where we talked about the importance of integrating a business intelligence (BI) strategy as part of your enterprise’s [···]

Read More