Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Excel connected to Power BI service (analyse in excel function) does not save credentials

Copper Contributor

Hello fallows,

 

I have a problem with Excel files connected to Power BI service (analyse in excel function). Till Christmas is was working well. Once I created a file I set the credentials and next time it did not ask me to set credentials again, so I could refresh these files during night using Task Scheduler and Macro.

 

Before Christmas it has broke. Every time I open the file it askes for credentials (does not matter if it is opened manually or by macro). I have read that macro (VBA) cannot set the credentials, do the macro stops.

 

Could anybody help me please?

 

Radka

0 Replies