I have a power pivot excel dashboard with pivot charts. I obtain the data by using the jira REST API to the source, and the query is scheduled.
I have tested access to the dashboard with my colleagues. For 2 people it returns a stack overflow error when trying to get data from source. And others it's absolutely fine and gets the data on the schedule.
Why would it return a stack overflow error for some and not others?
Looks like this was an issue as my credentials are embedded in the m code, but then users needed to have 'anonymous' selected for the credentials type. If it wasn't set to anonymous, users return stack overflow.
go to query tab>edit>data source settings>edit permissions> under credentials type: select anonymous.
Once you have set it once, it remembers for next time, however I'm trying to find a way that it will remember in the file itself instead of for each user, as I'll have to assist each user to select the anonymous credential type.
Link to supported method: Is there a way to bypass basic authentication in an Excel query?