Forum Discussion
Unable to Enable schedule refresh for dynamic data source (Source is Application Insights)
Hi Anonymous ,
you have to use the relative path parameter for the dynamic part like described here:
Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code Chris Webb's BI Blog (crossjoin.co.uk)
Hi Anonymous ,
you have to use the relative path parameter for the dynamic part like described here:
Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code Chris Webb's BI Blog (crossjoin.co.uk)
After using the RelativePath, I got the below error
Error : Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
When I tried to validate the credentials, I got the below error:
Error: Failed to update data source credentials: Web.Contents failed to get contents from 'https://api.applicationinsights.io/v1/apps/' (404): Not Found.
"https://api.applicationinsights.io/v1/apps/"& ParameterForEnvironment & "/query"
ParameterForEnvironment ID will come from the Report which is selected by the user, without this value the static URL won't work.
Thanks ImkeF for the solution.
I am able to see the schedule refresh in Power BI service. But when i try to refresh, i got the below error.
Error :
- Data source errorThe credentials provided for the Web source are invalid. Source at https://api.loganalytics.io/v1/workspaces/1232/query. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: TableName.
I have checked the "Data source credentials" and not able to see the "OAuth" option in "Authentication Method" and also tried with "Skip Test Connection", but got the same error.