Unable to refresh dynamic source (REST API) in powerBI service

[JayashriSuresh]

I am trying to refresh a dataset which has dynamic source data (via REST API).

The refresh works in Desktop but in the published version PowerBI service the refresh doesnt work.

I tried adding the relativepath concept, still I see the same error stating dynamic source cannot be refreshed.

M Query:

Source = Json.Document(

Web.Contents(

URL, [

RelativePath = "/rest/api/2/search?",

Query = [ jql= QUERY, fields={"customfield1","customfield2"} ]

]

)

)

ERROR:

This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.

• Data source for Query1

Could you suggest a way to fix this?

[Anonymous]

Hi @JayashriSuresh 

As you provided inside the link, if it's an unsupported data source, then the appropriate warning will appear. So are you sure that your data source is supported?

Best Regards,
Community Support Team _ Ailsa Tao

[JayashriSuresh]

Hello Alisa,

When I hit the refresh button from PowerBI Desktop, it refreshes my data and I see updated numbers in the visuals.

If not supported then, the refresh will not work at my desktop version too right? So I beileve the REST API should be supporting.

Thanks fo

Jayashri