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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Quentin_
Helper I
Helper I

Web.Contents - Error scheduled

Hi,

I try to configure an automatic refresh from PBi.com but I have an error message :

 

 

  • Source de données pour Adhérents
  • Source de données pour Ages

Query contains unsupported function. Function name: Web.Contents"

 

 

For these 2 tables, I use the function "Web.Contents" like the following example :

Source = Json.Document(Web.Contents("https://apirest.atinternet-solutions.com/data/v2/json/getRowCount?&columns={d_time_date,d_visitor_te..."))

 

I tried to insert an Apikey : [Headers=[#"apikey"="xxxxxxxxxxxxxxxxxx"]]   but when I want refresh Pbi show an alert message : 

 

"L'en-tête « apikey » est pris en charge uniquement lors de la connexion anonyme. Ces en-têtes peuvent être utilisés avec tous les types d'authentification : Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Referer"

 

Others calls of my report are based on the same api : https://apirest.atinternet-solutions.com/data/ and they need a basic authentification (user + password).

 

Have you got an idea to fix this problem ?

 

Thank you

1 REPLY 1
v-lili6-msft
Community Support
Community Support

hi, @Quentin_ 

You may refer to this blog:

Web.Contents(), M Functions And Dataset Refresh Errors In Power BI

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors