Error opening a power bi desktop file using VBA

[rafaelschmitz]

Hi All,

I'm trying to open a pbix file through a VBA code file after updating an excel database. I used the following commands in VBA:

MyFile = "filepath"
Cmd = "RunDLL32.EXE shell32.dll,ShellExec_RunDLL "
Shell (Cmd & MyFile)

But when it does that, Power BI starts with a error message that says: "Ribbon view has not been initialized"

Do you have any idea why I'm having this error? Is it the method I'm using to open the file? Do you know another way to do it?

Thanks,

[v-danhe-msft]

Hi @rafaelschmitz,

Due to I could not reproduce your problem, I suggest you ask the problem in below link:

https://github.com/dubravcik/PBIXRefresher

Regards,

Daniel He