Analyze in Excel when there are multiple pivot tables that require login verification for each one?

I'm having exactly the same problem.  This is a huge issue for me, since I create multiple very large data connected financial reporting packs using a Power BI data model as the source.  It requires me to login twice for every single connected object (a pivot table and a slicer count as two objects in this case).  If you just have one or two objects it's a nuisance, but when you have 35 different objects...that's 70 logins, which is totally bananas.  Has anyone found a way to resolve this???

And no, it's not a credential issue, as eventually, if I persist and get all the way through 70 stinkin' logins, it will finish refreshing.  Also, others in the organization are not having the same problem with refreshing the file.