Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Adapter gets old values in Power BI, but correct when running from Visual Studio - what's happening?

Hi!  I am developing an adapter with Power Query that is supposed to call our API for data after getting an access token through a token endpoint. It works fine now when running it from Visual Studi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

Based on my experience, usually The server will turn on the security policy that prohibits crawlers. In this case, we need to add an identification flag to the headers of the request.

 

like this:

#"User-Agent"="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36 Edg/106.0.1370.47"]

 

 

 

Best Regards,

Stephen Tao

 

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

That worked! Thank you so much. 🙂 

The previous calls seemed to use this as user-agent:

 User-Agent: Microsoft.Data.Mashup (https://go.microsoft.com/fwlink/?LinkID=304225)

So I don't know why that didn't work. 

Isn't it also really strange how the symptom is that one of the calls doesn't go out, and the other goes out with a completely random old token? 

Anyways, it works now, so thanks for your help, Anonymous !