So here is the problem, I want to create a buttun onExcel that leads to a Power BI file and I have no clue of how to do it, i also looked for this on Youtube but nothing is close or related to my question. Please help.

CodePudding user response：

Please test this code, adapting the paths and file name:

Private Sub cmdOpen_Click()

    VBA.Shell "C:\Program Files\Microsoft Power BI Desktop\bin\PBiDesktop.exe c:\pathToYourFile.pbix"

End Sub

You can improve this code passing the pbix filename as a variable.