AutoUpdate Database with Python

[Nicolas_Zim]

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?

[v-yuezhe-msft · Accepted solution]

@Nicolas_Zim,

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


Regards,
Lydia

[Syndicate_Admin]

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...

[v-yuezhe-msft]

@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]

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.

[v-yuezhe-msft · Accepted solution]

@Nicolas_Zim,

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


Regards,
Lydia

[Nicolas_Zim · Accepted solution]

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.

[v-yuezhe-msft]

@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]

@v-yuezhe-msft

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.

[Nicolas_Zim]

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.