CODEWITHSUNDEEP
sql-serverangularpowerbi-desktop
zarzou
zarzou

Reputation: 133

update the microsoft power bi report automatically when updating the databse

I'm generating some simple BI reports for a dashboard of KPIs in an angular App. Well my question is can power BI update the data of the report automatically whenever i update the database? .For the DB i'm using sql server .

Upvotes: 0

Views: 443

Answers (2)

Watsyyy
Watsyyy

Reputation: 125

You can use a python script to automate this, I have used this project before and it works https://github.com/dubravcik/pbixrefresher-python

You will need to convert the .py file into an .exe file and run it on a task scheduler and set your preferred execution rate.

Upvotes: 1

AnkUser
AnkUser

Reputation: 5531

This is what you are looking for

Real-time streaming in Power BI

There is one more way you can do that Data refresh in Power BI

I would put my 2 cents on Data refresh

Upvotes: 1

Related Questions