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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Nicolas_Zim,

Why do you need to auto update database info to Power BI Desktop file? After you publish the PBIX file to Power BI Service and configure gateway to set schedule refresh for the dataset, the report in Power BI Service will get updated automatically based on refresh schedule.



Regards,
Lydia

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