Python Part 20 - Power BI Desktop

By Andy Brown

This short tutorial shows you how to configure Power BI to find Python modules, how to load data from a pandas dataframe and how to base a Power BI visual on a matplotlib chart.

Chapters
00:00 Topic list
00:45 Configuring Power BI Desktop
02:35 Loading data from a Pandas dataframe
04:35 Creating a visual based on a matplotlib chart

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

[tejamarneni]

Hi Andy. Thank you for the Video. It's a really great explanation.

[elricho]

Excellent video, very well explained, thanks for showing us these possibilities with python

[juanpablohorn]

Hello Andy! I've whatched all of the videos that are available for the non-members. I find this tutorial really interesting! I would love to see this contunue. Either way, amazing content as always!

[jeetsakharkar]

Thankyou so much for ur efforts.
Can you also make a video on pyqt5

[ikennaudeani]

Could you create a Django and Backend Tutorial video?

[earlybird]

Hello, is it possible to update excel file automatically when open using python? In my example am getting data from a website (updating every minute) but to put data on excel, i need to close the excel file to view the changes.

[ikennaudeani]

Could you create a ML and AI python Tutorial video?

[debu]

Andy sir, you are exellent. sir, i have an annoying question out of the related video content. could you help me providing any your video link or any reference on how to add./write javascript code with VBA in "Microsoft scripting control" reference?.
I have commented hare to get a reply fast. please help me. Ten million love and thanks in advance and always.

[kolavithonduraski]

Do you recommend to switch from VBA to Python just for Office Automatisation... or is VBA enough when you stay in the "Office-World"

[BlueSkyGoldSun]

Can we make power Bi Dashboard using
Python visuals?

[wesdavis]

Does anyone know how to automatically refresh a datasource? Any python-based scheduling script I've written, which works amazingly for pulling data from a source/ file ever N minutes simply causes Power BI to hang.

I can pull data in power BI and I can automatically re-run that script outside of Power BI. I can't seem to figure out how to get power bi to recognize the scheduler functionality. I've tried APScheduler, and Schedule libraries. Both work great in the IDE. Won't work in PBI. There is obviously some limitation of Power BI to recognize and handle recurring jobs. To my knowledge, there is no built in way to do this either.

For the project Im working on, PowerBI Service(Cloud or whatever you want to call it) which does have auto refresh options, is not an option. This has to be a python based data pull that gets refreshed automatically

Example:

def prompt():
raw = <your api request)
d = json.loads(raw.text)
d = d ['data']
final_data = pd.json_normalize(d, max_level=1)
print(final_data)

sched.add_job(prompt, 'interval', seconds=30)

# Starts the Scheduled jobs
sched.start()

# Runs an infinite loop
while True:
sleep(1)