Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
RSGhelp
Frequent Visitor

Scheduled refresh not working for web source

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!

 

1 ACCEPTED SOLUTION
RSGhelp
Frequent Visitor

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)

View solution in original post

4 REPLIES 4
RSGhelp
Frequent Visitor

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)

Greg_Deckler
Super User
Super User

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.