dubravcik/PBIXRefresher

Error on PS console: unable to load file or assembly...UIAutomation.dll

Opened this issue · 5 comments

Hi,
i receive this error on ps console:

PS C:\program files\microsoft power bi desktop\bin> .\Refresher.ps1 -workbook .\testPBI_auto_update.pbix
Import-Module : Impossibile caricare il file o l'assembly 'file:///C:\program files\microsoft power bi
desktop\bin\UIAutomation.0.8.7B3.NET35\UIAutomation.dll' o una delle relative dipendenze. Operazione non supportata.
(Eccezione da HRESULT: 0x80131515)
In C:\program files\microsoft power bi desktop\bin\Refresher.ps1:9 car:1

  • Import-Module ".\UIAutomation.0.8.7B3.NET35\UIAutomation.dll"
  •   + CategoryInfo          : NotSpecified: (:) [Import-Module], FileLoadException
      + FullyQualifiedErrorId : System.IO.FileLoadException,Microsoft.PowerShell.Commands.ImportModuleCommand
    
    

Can anyone help me?

thanks

I had the same problem, can anyone help to overcome the error
Error on PS console: unable to load file or assembly...UIAutomation.dll

I had the same problem, help me please!

It looks like there is a problem with dependencies. I face the same problem when running on Windows 10 and this script was originally developed for Win7. Microsoft says that .NET 3.5 (the dependency) is feature on demand and has to be manually installed from image.
I found instructions how to install it (https://blogs.technet.microsoft.com/mniehaus/2015/08/31/adding-)features-including-net-3-5-to-windows-10/) however it wasn't successful on my machine.

As an alternative I'm re-writing this script in Python. I'll let you know once it is published.

oh man, so good!
Thanks !!!!

Hi guys, python version is here https://github.com/dubravcik/pbixrefresher-python. Please try it.
It works fine on my testing machines, hope it will work well on other machines :-)
Thanks