Forum Discussion

mzrkwcz's avatar
mzrkwcz
Helper I
9 years ago
Solved

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

Need Help
  • mzrkwcz's avatar
    mzrkwcz
    8 years ago

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

9 Replies