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!
Man MFA makes scripting so much harder 😭 I had written a selenium bot to automate one of my workflows at work but I ended up just having to make it manually sleep, waiting for the MFA screen to disappear (while I entered the code manually). Of course the answer is OAuth tokens but that's only for authorized interactions with services.... Edit: idk your org and haven't used Power BI yet, but it may be worth searching the web to see if an OAuth2 client token could be used to replace MFA. Like that's typically how scripts and apps are able to connect to Google services to do things like read from/write to the calendar api and other APIs
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)
In python I've scripted a program to listen for file changes using the watchdog library. Perhaps you write another python script that has access to that folder (which I'm assuming is network-attached storage) to have watchdog listen for when it is updated. Then after it's updated, you can then have it push up the change to your chart? Not sure if I'm addressing your question properly, but it seems doable
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 '00000009-0000-0000-c000-000000000000'. Can you please provide some context of the settings of the azure application?
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.
You can. But with API, you can trigger a data refresh based on an event. For example, suppose you have a webhook checks if new data/data file is uploaded to a cloud storage. Using API, you can automatically refresh a dataset when source data is updated.
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
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!
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.
Can you please explain, what does the App bearing that exactly do?
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?
Hi I have the same issue and cannot find any solution for that, is there someone who can help, please?
Man MFA makes scripting so much harder 😭 I had written a selenium bot to automate one of my workflows at work but I ended up just having to make it manually sleep, waiting for the MFA screen to disappear (while I entered the code manually). Of course the answer is OAuth tokens but that's only for authorized interactions with services....
Edit: idk your org and haven't used Power BI yet, but it may be worth searching the web to see if an OAuth2 client token could be used to replace MFA. Like that's typically how scripts and apps are able to connect to Google services to do things like read from/write to the calendar api and other APIs
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)
In python I've scripted a program to listen for file changes using the watchdog library. Perhaps you write another python script that has access to that folder (which I'm assuming is network-attached storage) to have watchdog listen for when it is updated. Then after it's updated, you can then have it push up the change to your chart? Not sure if I'm addressing your question properly, but it seems doable
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 '00000009-0000-0000-c000-000000000000'. Can you please provide some context of the settings of the azure application?
i also meet ur problem. Do u fix this problem? Can i have ur solution? Much thankssss
Great Tutorial. Is it possible to automatically run the Python script when a user refreshes the report?
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.
Will look into it. Power BI API is still in its early stage to be honest.
Hi, That was Amazing. Is there any possibility we can cancel the schedule refreshed setup with API. Thanks in Advance.
Let me look into it.
@@JJPowerBI ok
how to solve?
from acct_info import username, password
ModuleNotFoundError: No module named 'acct_info'
acct_info module is just a file I created specifically to store my user credential. You will have to create the file (acct_info.py) yourself.
@@JJPowerBI You could share your so to compare with my
@@adilsonpinto2752 It's just a module with simple variables.
@@JJPowerBI Can you show this step for us amatures?
Can't I just schedule a refresh in PowerBI?
You can. But with API, you can trigger a data refresh based on an event. For example, suppose you have a webhook checks if new data/data file is uploaded to a cloud storage. Using API, you can automatically refresh a dataset when source data is updated.
@@JJPowerBI 👍 🙏 would love more content. Excellent tutorial style!
where can i find the username and password
HI friend, did you find an answer?