Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
mzrkwcz
Helper I
Helper I

Data source does not update in web Power BI

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 defined in Power BI DesktopData Source in cloud Power BI, auto refresh error shows old value of "filter_id"Data 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.

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

View solution in original post

9 REPLIES 9
v-yuezhe-msft
Employee
Employee

@mzrkwcz,

Could you please post the above error message in English?

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Regards,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors