Can't refresh a report based on OpenData

[daniele_tiles]

Hi to all,

a collegue has made a nice report based on a lot of OpenData (accessed with CSV.Open(Web.Content()) and some data published on a Dropbox. The report updates correctly on Power BI Desktop, but there is no way to update it through Power BI Service. We get a message that the scheduled refresh is disabled, because we are missing a credential (I'll post here the message, it's in italian, but that's what it says).

L'aggiornamento pianificato è disabilitato perché mancano le credenziali per almeno un'origine dati. Per riavviare l'aggiornamento, passare alla pagina delle impostazioni di questo set di dati e immettere le credenziali per tutte le origini dati, quindi riattivare l'aggiornamento pianificato.

However, when we go to check in the Settings, there is no way to set any credentials.
I believe there is no dynamic URL (I GUESS), any ideas?

Thank you

Daniele

[aj1973 · Accepted solution]

Hi @daniele_tiles 

I think your Power Bi service trying to connect to the dropbox is the issue.

check these threads, it might help.

https://community.powerbi.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=fals...

[aj1973 · Accepted solution]

Hi @daniele_tiles 

I think your Power Bi service trying to connect to the dropbox is the issue.

check these threads, it might help.

https://community.powerbi.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=fals...

[daniele_tiles · Accepted solution]

Hi aj973,

thank you for your answer: I believe we've found the problems:

1. There is one connection that use the HTML(Legacy) mode, which is Web.Page(Web.Contents
2. There is a one connection that scrapes a a website which has got a parameter in the URL.

I believe this 2 connections are the problem, because when we deleted the tables and published, we were able to see and set the credentials for all the other URLS

[aj1973]

You are welcome,

Please mark the thread as solved for the rest of the community