Forum Discussion
Data source does not update in web Power BI
> Did you solved this issue using pipedrive api ?
Yes, I did. Clearing all permissions in "Data Source Settings" in Power Query Editor in Power BI Desktop app and then setting them again and publishing to the cloud refreshed requests done by Power BI Cloud.
mzrkwcz,
Could you please post the above error message in English?
Regards,
Yes, I have added in my post:
The error message above in English:
"Failed to update data source credentials: Web.Contents failed to get contents from 'https://api.pipedrive.com/v1/deals?filter_id=29&start=0&limit=500&api_token=XXXXXXXX' (400): Bad Request"
It is because "filter_id=29" does not exist anymore in Pipedrive CRM. "filter_id=39" exists but the URL does not update from PBI Desktop.
Even worse - for any call for data to https://api.pipedrive.com/v1/deals PBI clud attaches the same old set of URL parameters I do not use anymore (filter_id=29&start=0&limit=500&api_token=XXXXXXXX), even in new PBIX files!
mzrkwcz,
Change your code in Advanced Editor following the instructions in the similar blog and thread below, then check if you can refresh successfully.
https://www.powerpivotblog.com/getting-data-into-power-query-with-the-twitter-search-api-how-to-hack-pq-to-use-oauth/
https://community.powerbi.com/t5/Service/Refreshing-a-Restful-Data-Source-with-API-Key/td-p/131298
Regards,
Lydia ZhangI'm having the same problem. I can't find the old URL parameter string in the Query Editor using the Advanced Editor. I don't think it's in the Power BI Desktop file. I think the old parameter string must be hanging around in Power BI Web. But I don't know how/where to edit or remove it.
Well, it's not the same. I see URL parameter string in the Query Editor, and it works well in Power BI Desktop, but Power BI Service keeps using previous version of this URL (same domain, changed URL parameter). Publishing does not update the query URL :-(
