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

sergiorru's avatar
sergiorru
Regular Visitor
8 years ago

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's avatar
mzrkwcz
Helper I
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.

  • WorkHard's avatar
    WorkHard
    Helper V
    6 years ago

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