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.
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 :-(
I am still stuck. I even removed all datasets, reports and dashboards and uploaded them again. No change.
Power BI keeps using some old URL querying for the data, different from URLs that are defined in the Desktop Power BI.
In the Desktop Power BI I have, for example:
= Json.Document(Web.Contents("https://api.pipedrive.com/v1/deals?&filter_id=21&limit=500&api_token=XXXXXXXX"))
And Power BI Servive keeps querying:
https://api.pipedrive.com/v1/deals?filter_id=29&start=0&limit=500&api_token=XXXXXXXX
This is very frustrating. Power BI service keeps telling me:
"Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again."
And:
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
Activity ID: 206834fd-4c7d-475f-886b-1535772de82d
Request ID: 7c317670-588a-1128-dfdb-d2e24d2d3420
Status code: 400
Time: Fri Jun 16 2017 14:27:13 GMT+0200 (Środkowoeuropejski czas letni)
Version: 13.0.1700.2477
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net
url
https://api.pipedrive.com/v1/deals
What can I do to solve this?
Hi mzrkwcz,
Did you solved this issue using pipedrive api ? I facing the same issue when try to publish the dashboard on the PB portal.
The API uses the Anonymous conection but the portal cannot update the data.
Follow a sample of my call on the api to get deals:
Web.Contents(
"https://api.pipedrive.com/v1/deals",
[
Query =
[
api_token = PipeDriveApiKey,
status = "all_not_deleted",
limit = Text.From(items_per_page),
start = Text.From(page_num * items_per_page),
owned_by_you = "0"
]
]
)> 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.
I'm having the same exact issue and clearing the permissions and resetting them didn't fix this.
What else should I try for the power bi web cloud service to refresh that URL? It's displaying an old URL....
