Forum Discussion
Can't schedule refresh as Web.Content is used
Super UserHi zoubeyrB
Assuming you have something like this:
Click on Edit credentials
Choose your authentification and privacy level (https://learn.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels)
Schedule away 🙂
Thanks for your answer SamWiseOwl ,
Unfortunately, I don't have access to the "Data source credentials" section (the only datasource is the web page).
- SamWiseOwl
That would suggest the connection is being treated as a local data source.
When I connect directly to some data sources it uses Web.BrowserContents which is connecting to the data through my browser hence a local source. Changing it to Web.Contents fixes this issue as it become an online data source.
The lazy fix for this is installing a Gateway and connecting through that.
A gateway lets Power BI Service connect to the data source through your computer.
For example connecting to a SQL database on a server or an Excel file on your desktop.
Sadly if you install one then the refresh will only happen when your computer is turned on.
The harder part will be working out why it is treating your online data source as a local one!
- SamWiseOwl
Could you try creating the datasource directly in Power BI Service and see if that has the same credentials error.
In the workspace choose New, DataFlow Gen1.
Then when you see the data connectors click more and choose Blank Query.
Paste in your M code from above and see if it can pull the data.Thanks for the suggestion,
When I use dataflow I have a similar issue :
I don't know how to connect the report to the webserve (https://gitlab.xxxxxx.fr/api/), I do manage to get tickets using Postman.