I'm trying to access data from ApplicationInsights as an "anonymous" (using web connector in power bi desktop) and the refresh works fine in Power bi desktop. However, when I'm trying to sign in to set the refresh on service, it's giving an"Invalid credentails" error.
However, when I did it, I'm getting another error of "404: not found".
In the same thread, there's a workaround mentioned by @fso executing query somewhere else (eg. by using Google spreadsheet) something that I'm not familiar with. What exactly is this and how this works in my case (where I need the scheduled refresh every 24 hours)?
Or is there an alternative workaround for this, Can anyone please direct me in the right path?