Forum Discussion
Powershell to refresh Excel with OLAP Query. Credential issues
Hi Experts, I'm rather new with PowerShell scripting so please be patient with me 🙂 I have multiple excel file with OLAP Query connections connecting to Power BI Datasets, following are the ...
ZuheirAshraf Did you eventually solve the issue? I have a similar problem and would be very happy to see the solution!
JKrook Unfortunately, I couldn't find a way to bypass the UI sign in. So we ended up setting an agent machine to run the script with visible option true with the excel already pre-sign in with specified credentials.
Up till now seems to work fine and doing its job on daily basis.