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

So apparently this did only fix the issue temporarily. I just got the same behavior once again, when trying to import some new data from the data source. 

What's funny is, if I change the User-Agent to something new, for instance by changing a version number, it works again for a while, then goes back to the same issue after a while. 

Pushing refresh on the data after including it in a report works: It gets a new token, then refreshes the data using that token. The problem usually occurs when going into the Get data dialog, and sometimes from the Transform Data window. 

Is there something else I could try to get it more stable? Could this be a bug in Power BI / Power Query? Nonetheless it's some pretty strange behavior.