Forum Discussion
Analyze in Excel when there are multiple pivot tables that require login verification for each one?
Hi JeremyQiu
1.Please check the date source authentication in date source settings in service to make sure the authentication is not expired.
2.Please make sure your pivot tables have the same data source.
3.You can try to clear the cache of the broswer, then try to use 'Analyze in Excel'
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Thank you for your reply.
But my credentials have not expired, and the data sources are all from the same PBI Dataset. When refreshing the data, I need to repeatedly click to select an account without entering a password. Just need to click multiple times to select the account.
And when I copy a pivot table and replace the measures in it, I also need to reselect the account.
In addition, I cleared the browser cache and re downloaded Analyze in Excel, but the above situation still occurs.