Forum Discussion
rafaelschmitz
7 years agoNew Member
Error opening a power bi desktop file using VBA
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,
1 Reply
- v-danhe-msft
Microsoft Employee
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