Data source does not update in web Power BI

[mzrkwcz]

I have a problem with Web, JSON data source (Pipedrive CRM API).

I have updated the URL used to get the data and it works flawless. But when I publish to web Power BI the URL stays the same, and I automated data update does not run. I tried to remove the data from cloud and publishing again, but it dodes not help. Any suggestions?

Data source defined in Power BI Desktop:

Data source defined in Power BI DesktopData Source in cloud Power BI, auto refresh error shows old value of "filter_id"

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.

[v-yuezhe-msft]

@mzrkwcz,

Could you please post the above error message in English?

Regards,

[mzrkwcz]

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!

[v-yuezhe-msft]

@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...
https://community.powerbi.com/t5/Service/Refreshing-a-Restful-Data-Source-with-API-Key/td-p/131298

Regards,
Lydia Zhang

[dathompson]

I'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.

[mzrkwcz]

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 😞

[mzrkwcz]

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?

[sergiorru]

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"
              ]
        ]
)

[mzrkwcz · Accepted solution]

> 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.

[WorkHard]

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....