SharePoint Connoisseur

Harry Chen's SharePoint tricks and tips

Friday, October 23, 2020

›
In Power BI dataset, you could use PowerShell to refresh the dataset. Here is the sample script to refresh Here is the script to refresh dat...
10 comments:

PowerShell script to update Power BI Dataset parameters

›
In Power BI dataset or reports, parameters serve as a way to easily store and manage a value that can be changed after deployed. You could s...
2 comments:

How to configure Power BI dataset to connect to different databases in different stage workspaces?

›
When working in Power BI deployment pipeline, different stages may have different configurations. For example, each stage can have different...
1 comment:
Monday, September 28, 2020

Power BI new column based on other table

›
 We have a Power BI report need to get the total "Approver Tasks" for one submitted "PubsRecord". There are few options ...
1 comment:
Thursday, September 17, 2020

Power BI Dataset Refresh Error for Column in Table contains a duplicate value

›
We have a Power BI dataset and report running for few month without refresh error. However it shows the following error and refresh stops. C...
1 comment:
Tuesday, June 30, 2020

How to Sort by Month Year Name in Power BI report

›
When you create Power BI report based on Month and Year calendar, the default sorting i s based on the alphabetic name like then screenshot ...
9 comments:

Power BI Streaming Dashboard example

›
There are many different ways to present real data report and dashboard in Power BI. One of the way is to use PubNub that could make your da...
3 comments:
›
Home
View web version

About Me

My photo
Harry Chen
View my complete profile
Powered by Blogger.