Wednesday, June 24, 2020

Create summary table and ensure no empty value for Power BI

›
If you need to create a summary table for Power BI report, you should be careful not to return empty value. Here is one example. NoActionT...

Power bi calculated column multiple if statements example

›
We have a requirement to display the percentage distribution in Power BI. The percentage can be any value from 0% to 100%. However, the repo...
Thursday, June 18, 2020

Populate user office location for Power BI

›
There is a need to populate user office location for Power BI. Here is one of the quickest way to get this information trough AD Powershell ...
Monday, June 15, 2020

Power BI for LMS365 learning data

›
In order to get learning data from cloud LMS365, you could use either connector for Microsoft products like Logic Apps, Power Automate, and...
1 comment:
Thursday, June 11, 2020

How to invoke Azure function inside PowerShell or Azure Runbook

›
The way PowerShell to call Azure function is same as call rest web service . There are few tips as below. Use client object module and a...

Tips to filter Power BI report using query string parameters in the URL

›
With increasing usage of Power BI report, there is a case that users request to have a link on the SharePoint list to query all related in...
Friday, February 21, 2020

How to use REST API call to query SharePoint list over 5000 threshold?

›
We have a SharePoint SPFx project that is using SPFx JS and REST API to query few large SharePoint lists with over 5000 items. We got the fo...