Forum Discussion
Power BI connection to excel stopped working
To anyone else having the same issue i found the reason and managed to fix it.
Somehow (probably due to long time of olap cube refreshing) the excel disabled external data connections in the trust center.
I enabled it and it started to work again.
Its resolved now.
Hi juraj_slatina_a ,
You're connecting data from Power BI with Excel and then it's not refreshed successfully, is it?
If Excel's connection to Power BI is fine, have you checked if the data in Power BI refreshed successfully?
“Its strange that new connection works only for a few hours as when I try to play with it the next day it doesn't answer as the old connection”
Do you use Rest API for the problem you mentioned above? If an access token is used, note that an acess token will get expired after 1 hour.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
To anyone else having the same issue i found the reason and managed to fix it.
Somehow (probably due to long time of olap cube refreshing) the excel disabled external data connections in the trust center.
I enabled it and it started to work again.
Its resolved now.