Forum Discussion

ApoorvaReddy's avatar
ApoorvaReddy
Frequent Visitor
6 years ago

URGENT Help needed - Unable to refresh the model because it references an unsupported data soource

Hello Pals, I am struggling to run the M code in Power BI service to refresh the data while it works fine in desktop. After i publish to service, the dataset renders an error: “Query contains unsupp...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi ApoorvaReddy ,

 

Since you could refresh it, you could use Query in Web.Contents to add some constraints so that prevent endless refresh.

Here is a document for your reference.

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/

And you said that there will be duplicate data after refreshing? You could use Table.Distinct() fcuntion to remove duplicate data.

 

ApoorvaReddy's avatar
ApoorvaReddy
Frequent Visitor
6 years ago

Hi,

 

I could not use any constraints in the web.contents as we need to pull all the data, however i tried to use data parameter to reduce the incoming data, the loop keeps running as never stops.

 

Duplicates can be restricted in visualizations, which is not a problem here. We somehow needs to end the for loop and i am not sure where the culprit is. The difference between original (refresh works fine in desktop) and modified script is (refresh works fine in Service but endless loop), i just added relative path to the modified script and everything else is same.

 

I am using below URL to come up with cursor based pagination as there is no paged-based pagination available from API call.

https://datachant.com/2016/06/27/cursor-based-pagination-power-query/#comment-22206