Forum Discussion
Helper IVCan't refresh a report based on OpenData
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
I think your Power Bi service trying to connect to the dropbox is the issue.
check these threads, it might help.
Hi aj973,
thank you for your answer: I believe we've found the problems:
- There is one connection that use the HTML(Legacy) mode, which is Web.Page(Web.Contents
- 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
3 Replies
- aj1973
Community Champion
I think your Power Bi service trying to connect to the dropbox is the issue.
check these threads, it might help.
daniele_tilesHi aj973,
thank you for your answer: I believe we've found the problems:
- There is one connection that use the HTML(Legacy) mode, which is Web.Page(Web.Contents
- 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