Automate Dataset Refresh With Power BI API Using Python

In this Power BI tutorial, we will learn how to refresh Power BI dataset using Power BI API with Python. By being able to refresh dataset programmatically, we open the door to more possibilities to give us more options on refreshing a dataset based on conditions.

▶ References:

☕ Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
🔑 Venmo: @Jie-Jenn

💳 Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#PowerBI #PowerBITutorial #PowerBIAutomation #PowerBIAPI

[nietzschebietzsche]

Fantastic! I'm working on a dashboard project and I am having to pull down data in Python so I was looking for a tool that will let me make charts that will automatically update when I pull in new data to files. It looks like Power BI is going to be the way to go!

[meierthomas]

Great Tutorial. Is it possible to automatically run the Python script when a user refreshes the report?

[adrianricoalonso]

This was super helpful but please, important question, is there anything special that has to be configured in order to get the token with your user o pass, when i try to get the token via spn everything is okay, but when i try with username and pass with the code of the video i get an error: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access Can you please provide some context of the settings of the azure application?

[tanababa]

Hello, thank you for the great script.
I get an error due to the MFA set by my organization. Is there a way to add a code that will deal with it?

[JorgeEscobarMX]

I wonder how the app was created in azure. It seems like it was already created and I don't know how to make one.

[j.bagalay]

Hello, I am just thinking if the Python can be the solution.

For context:
We have a Dataset that is also connected to a local folder (csv extractor) and we have a team who created a scheduled script. Meaning, they set up a specific time of when will the data be dump to that folder then once receive that, we will need to manually refresh the dataset in PBI desktop then publish (we do it daily)

[ManojKumar-vpzj]

Hi, That was Amazing. Is there any possibility we can cancel the schedule refreshed setup with API. Thanks in Advance.

[adnanazad]

If we can use some python method to set up new Power BI report usage metrics to cover multiple workspaces for a company that will be very handy, haven't found a tutorial that explains it clearly step by step.

[muizzhaque]

where can i find the username and password

[chriskeo]

Can't I just schedule a refresh in PowerBI?

[adilsonpinto]

how to solve?

from acct_info import username, password
ModuleNotFoundError: No module named 'acct_info'