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.

Nicolas_Zim's avatar
Nicolas_Zim
Regular Visitor
7 years ago

Because, i dont know why... i tried with just gateway, but it doesn't work.
After this i tried update manual in PBI Desktop and push to PBI web, and this way worked. So i am trying to autoupdate for just push the info in PBI web.

 

Anyway i need to update every 30minutes or something like that, if i use the update schedule of PBI web i can't have this update pattern.

However if you know a way to follow for help me, i will be gratefull.

Thanks for attention, 
Nicolas.

Anonymous's avatar
Anonymous
Not applicable
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
    Regular Visitor
    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Nicolas_Zim，

      "The autoupdate every 30 minutes. Wich isn't will work with schedule of PBI Web".

      Could you please describe more details about the above sentence? If you have configured gateway succesfully and add yor data sources within the gateway, you are able to set 30 min refresh schedule if you have Power BI premium license.

      Regards,
      Lydia

      • Nicolas_Zim's avatar
        Nicolas_Zim
        Regular Visitor
        7 years ago

        I will not be in the place where PBI will be running, so I need to leave some script running to update itself.
        With the PBI agenda I can only do 8 update times.