Query contains unknown or unsupported data sources.

[jagrutijoshi]

Hi,

I am fetching data using Hubspot API URLs into Power BI. In order to fetch data for all marketing campaigns at once from Hubspot, I'm creating a dynamic query that uses 'campaign_id' as a parameter and fetches data for all given campaign_ids in one table. I get the list of campaign_ids using another API URL. This dynamic query works fine in Power BI Desktop but when I publish my report to Power BI Service, I get the following error-

Is there a workaround or alternative method through which I can use dynamic queries with Power BI Service? Any help is appreciated.

[dcresp]

I think this blog post by Chris Web should assist in this instance. 

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

[Manuel1]

I had a lot of problems with this today.

I think they should give some kind of warning about that...

[v-shex-msft]

Hi @jagrutijoshi,

Current dynamic custom function still not works on power bi service, please submit this requirement to ideas.

Regards,

Xiaoxin Sheng