Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I'm trying to schedule a resfresh but I am getting the following error
Processing error: | Web.Contents with the Content option is only supported when connecting anonymously |
It is correct, I use basic login functionality on a source. Username/password. What steps do I need to take to connect anonymously?
The query looks like this
let
Source = Xml.Tables(Web.Contents("https://secure.clockwise.info/clockwise/Mycompany/export/export.php?aktie=exporteer&cwtblexport/53/1...")),
Table0 = Source{0}[Table],
etc.
Thanks!
Solved! Go to Solution.
I fixed this by adding [Headers =[#"Authorization"="Basic XXXXXX"] to my source call.
The XXXX is username:password encoded in base 64. (google it for a converter)
I fixed this by adding [Headers =[#"Authorization"="Basic XXXXXX"] to my source call.
The XXXX is username:password encoded in base 64. (google it for a converter)
@RSGhelp - That's an odd one, you say you are connecting using a username and password but the error is saying that you are only allowed to connect anonymously?
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Yes, I use the "basic" login functionality which uses a username and a password. The data refreshes fine in PowerBI desktop. The trouble comes when using the scheduled refresh on the app.powerbi.com.
@RSGhelp - I'm thinking support issue then, it's notoriously hard to troubleshoot Service refresh errors most times.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
30 | |
24 | |
22 | |
20 |
User | Count |
---|---|
57 | |
41 | |
24 | |
24 | |
21 |