Infinite OLAP Refresh Loop

[Twollaston]

Good Afternoon,

I have an excel workbook in which there is a pivot that is connected to power BI. When I attempt to refresh this pivot I get stuck in an infinite refresh loop forever. It just says the following things over and over again:

• Running OLAP query
• Refreshing the OLAP cube
• Waiting for query to be executed

I tried to troubleshoot it on the internet but i'm not really finding anything relevant to my situation. I was wondering if anyone had any ideas I can use to troubleshoot this problem, or if anyone has had the same issue before.

Thanks

 

[mole999]

What code in the workbook relates to it?