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_text_id,m_visits}&sort={d_time_date}&filter={d_visitor_text_id:{$empty:false}}&space={s:xxxxxx}&period={R:{M:{start:'-12',end:'-6'}}}&max-results=10000"))

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