Scheduled refresh failing for report with PWA custom columns

[Anonymous]

Hi all,

I have created report that connects to our PWA site. The risks and issues pages in PWA have been modified to include custom columns which I know Power BI is unable to pull through that data by default. To get the information I've had to connect to the site using a REST API and the report in desktop works absolutely fine and published fine. However my automatic refresh has since started failing and I've since found it's because Power BI doesn't at the moment support this.

Does anyone know of any workarounds because I need this data in the reports.

Thanks.

[Anonymous]

Just wanted to say thanks for the responses. I'll be looking at this tomorrow.

[Anonymous]

Looking further into this it definitely isn't possible to have a scheduled refresh when you have MS Project custom fields in the report. The only possible workaround is to use Power Automate so the data is available in Azure which can then connect to Power BI (https://pwmather.wordpress.com/2020/04/07/want-to-report-on-projectonline-project-site-list-data-exa...). Sadly we don't have Azure so it looks like it's going to need to be Excel to get access to this data centrally.

[v-yingjl]

Hi @Anonymous ,

You can try to use Web.Contents() in power query.

Refer this blog: https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/

If not help, you can share some screenshots or error meesage about this issue for further discussion.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , not very clear. Create a new pbix and add the data source again. In data transformation mode, right click on table and open advance option and take the new code, replace this in old file, before any modification was done in that file.

refer

https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/
https://www.youtube.com/watch?v=_8dJ--ktU4c