Forum Discussion

brenotte's avatar
brenotte
Regular Visitor
9 years ago

Command line to open/refresh/publish PBIX

Hi,

 

On my customer context it's out of question to use OnPremises Data Gateway.

But we still need to schedule refresh.

We thought about command line otpions to open/refresh/publish PBIX.

We tried this PBIXRefresher but without any success.

 

Does anyone have tried and succeed to achieve this ?

 

Thanks a lot for any help.

 

Regards,

 

 

Need Help
Tips and Tricks

7 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi brenotte,

     

    Here is an idea about programmatically refreshing PowerBI Desktop files data. You can vote it up and add your comments there to improve Power BI on this feature. :smileyhappy:

     

    In addition, from one comment of the idea, a workaround of using Power Update was mentioned. Could you go to check if it helps in your scenario? 

     

    Regards

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Did you install the UIAutomation libraries? I'm not aware that Microsoft has really opened up Power BI Desktop to automation like this in the same way as Excel, Word, etc. Back in the day, I remember that we used to use a start-up macro in Excel that would perform the refresh and then save the file but I'm not aware of that kind of functionality in Desktop.

    • brenotte's avatar
      brenotte
      Regular Visitor
      9 years ago

      Hi,

       

      Yes i tried but without any success

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi brenotte , any solution to this topic?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I have the same issue, i'm trying automate the process with without sucess.