Refresh issue using HTML Content visual OR How to retain HTML format from Project Online data source

[Anonymous]

I am using an HTML Content visual in my Power BI report.  It works well in Power BI desktop, however I can't refresh the report in Power BI service.

I get an error saying trying to reference an unsupported data source.

I am able to refresh it in Power BI desktop successfully.

We use oData.feed to access data from Project Online.

To get the raw HTML data from Project Online I had to create a function using the internal custom field name.

Ultimately I am trying to extract data from Project Online and retain the HTML formatting when the field comes across to Power BI.  So any other suggestions on how to achieve this would be grateful.

Thanks

[v-kelly-msft]

Hi @Anonymous ,

Based on my test,it's a data source issue,pls check below link for reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-admin-troubleshoot-unsupported-data-source-for-refresh

Below is a video about HTML Content visual which may help:

https://www.youtube.com/watch?v=HgkT8hLQ2j8

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[manikumar34]

@Anonymous,

Someone had posted the workaround about the same. 

Please check the below link. 

https://community.powerbi.com/t5/Power-Query/WORKAROUND-How-to-use-scheduled-refresh-of-a-web-page-without/m-p/1434043#M44835

I hope this will solve your problem. 

Regards, 

Manikumar 

[lbendlin]

Play around with the base URL setting for your data source to see if you can make the service like it more.

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