Forum Discussion
Convert Dynamic Data source
- 2 months ago
Hi jimbob2285 ,
Thank you for reaching out to fabric community.
According to Microsoft's documentation, most dynamic data sources cannot be refreshed in the Power BI Service. A documented exception is using the RelativePath and Query options with Web.Contents. Since your token endpoint is fixed, you may want to restructure the request around a static base URL (for example, https://api.iris.co.uk ) and use RelativePath = "oauth2/v1/token" instead of passing the full URL directly to Web.Contents, then check whether the query is still identified as a dynamic data source.
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data#refresh-and-dynamic-data-sourceshttps://learn.microsoft.com/en-us/powerquery-m/web-contents#about
Thanks!!
Hi jimbob2285 ,
Thank you for reaching out to fabric community.
According to Microsoft's documentation, most dynamic data sources cannot be refreshed in the Power BI Service. A documented exception is using the RelativePath and Query options with Web.Contents. Since your token endpoint is fixed, you may want to restructure the request around a static base URL (for example, https://api.iris.co.uk ) and use RelativePath = "oauth2/v1/token" instead of passing the full URL directly to Web.Contents, then check whether the query is still identified as a dynamic data source.
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data#refresh-and-dynamic-data-sources
https://learn.microsoft.com/en-us/powerquery-m/web-contents#about
Thanks!!