Forum Discussion
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 information.
However i am using an ODBC for use FDB file database and a gateway to update the data of PowerBi Desktop to PowerBi Web. Its working, with manual update, but i can't find a way to update with python.
Comments: I have never used python or R scripts inside PowerBi.
It's out of the question to have python manually click on buttons to update.
I'm trying get some API or some library with python.
Visual example of what I want to do.
I'am using ODBC in this way.
Not sure how to proceed, but i need some way to go.
Could I have some help?
What error message do you get when using gateway? Do you successfully add SQL data source within gateway?
Regards,
LydiaSorry, 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.
8 Replies
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,
LydiaBecause, 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.What error message do you get when using gateway? Do you successfully add SQL data source within gateway?
Regards,
Lydia
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...
