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，

"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

lukas1's avatar
lukas1
Frequent Visitor
7 years ago

Anonymous

 

Thank you very much for the answers so far. 

I am having similar problems.


I just wanted to ask if it's possible to "autoupdate" in Power BI Service every 30 min. or every hour without having a Power BI premium license? (I have only  Power BI pro).

 

Thank you.