Forum Discussion

Nicolas_Zim's avatar
Nicolas_Zim
Regular Visitor
7 years ago
Solved

AutoUpdate Database with Python

My requirement is create a script with autoupdate the DataBase info to PowerBi Desktop (like every 30minutes) and after that, update the data for PowerBi Web, for use the reports with daily informati...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Nicolas_Zim,

    What error message do you get when using gateway? Do you successfully add SQL data source within gateway?


    Regards,
    Lydia

  • Nicolas_Zim's avatar
    Nicolas_Zim
    7 years ago

    Sorry, i make a mistake. I thought the gateway works with the PBI online, and if it were so i would need use ODBC too.
    And then, gateway works alone, without the ODBC and PBI opened in the desktop. I make tests and works.

     

    However i am still with a problem to solve. The autoupdate every 30 minutes. Wich isn't will work with schedule of PBI Web.
    I am searching for some way to make python autoupdate the database file in PBI Web.

    But anyway thanks for it, helped me a lot.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

What about using Power Automate to schedule a BI update every 30 minutes? That gives you the ability to pick any recurrence schedule and if you need python you could call a Power Automate Desktop to do that then refresh...