Is it possible to create a card in python visual as show data in that card dynamically ??? I mean with changing the value of the slicers, the value of the card will change too but the card along with the value should be created in python visual ???
Thank you for the demonstration! Quick question, could I output a data set from the Python script? For example, if I load the fields in the same way you did, could I then process the data and generate an tabular data out of it? Many thanks, just subscribed!
HEJ. Is it possible to bypass the line "remove duplicates rows", sometimes in some cases it may iterfere? if somebody knows how to do it please share. THX
I had the same problem, but when I heard the "drinks dataset" mentioned, I started searching the internet. You can find the data at: www.kaggle.com/navneethc/drinks. To download the dataset you do need an account.
Great video, still relevant after an year. I just had a small doubt though. Is it possible to add data labels to the plots or make them available with a mouseover action
I am trying to uncompressed a column in a dataset using pandas and lzstring. I have used this syntax but the Python script errors with TypeError: 'function' object is not subscriptable # 'dataset' holds the input data for this script import pandas as pd import lzstring as lz df = pd.DataFrame(dataset) df['DecompreseedAssets'] = lz._decompress['MigratedAssets'] MigratedAssets column has data that is compressed using lzstring Could you help please?
Hi, can you make the violinplot interactive like the standard one in PowerBI? I mean so you can mouse over it to get info on median, average and so on..?
I have an error: python visuals are currently disable in your organization!!!! so, is python scripts only visible on the Microsoft cloud? and don't visible on the report server?
Hey Joshua, a couple others (besides matplotlib and seaborn) that I use are ggplot and geoplotlib. I haven't tried them in Power BI yet but will be soon. I assume that plotly will not work natively in a Python Visual as it doesn't in an R visual, but that might be something to try out
Hello... Thanks for the video. I however have a question regarding Python and Power BI visuals. I hope that you can give me some lights on how to go through the solution. I believe that you are aware about the Narrative Visual that convert any graph to a narrative. I'm looking for a way using Python (or else - I prefer Python) to take control over that Narrative Visual and pass the narrative text in a variable converting it to Audio and play it in another Python Visual. Is it possible ? if yes how ?
Hi. Any suggestion to fix this? community.powerbi.com/t5/Issues/Bug-in-python-visual/idi-p/487259 The issue seems to be the comma "," as decimal separator
+Fabián Álvarez I just took a look at the issue and I don't have an idea how to fix it, sorry. I imagine that's a locale problem that Microsoft will need to fix in the future. Sorry for your trouble 🙁
6 років тому+1
@@BIElite Yes, I believe that too. I'll be patient and wait for a fix from Microsoft. Thank you for your support. 👍🏼
Not sure that this is in the plans any time soon. R visuals have been out for years without interactive visuals being released. You can make your own interactive R visuals by creating a custom visual, but this isn't supported with Python yet I believe.
This is a fascinating work through. Thank you for that. But in the power BI web, how to make the python related visuals and script working ? Hope you can make another video on that topic. Thanks.
+ynwtint I don't think the visuals are supported yet. You can run Python scripts if you are connected to a personal gateway. I haven't tried this yet but I am planning to. I'm hoping that Python becomes generally available in this month's update
Thanks for the compliment Nama! I think you can create Python custom visuals. That's an assumption though. I have been thinking about creating a Plotly custom visual when I get the time
+Carlo Ezra Martinez Ruiz yes to a degree! You can write a python script inside of a Python visual which will make the code execute every time there is a slicer or visual change. It's pretty handy
Interactive calls in the Python script, such as waiting for user input, halts the script’s execution. Refer: docs.microsoft.com/en-us/power-bi/desktop-python-scripts
I hope it’s not to late, but you can find seaborn and matplot lib galleries online. I really like to browse through them to search what I need for every specific case.
Great job man - REALLY appreciate these walkthroughs - makes a big difference at work!
+M W thanks for the feedback! I'm glad you're getting something out of them
Love that python is now in PBI. Please keep making python videos, really excited to get ideas on what to do with it.
+931202aj you and me both!
THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!! Your steps were the only ones that fixed my no module matplotlib and pandas error
Is it possible to create a card in python visual as show data in that card dynamically ???
I mean with changing the value of the slicers, the value of the card will change too but the card along with the value should be created in python visual ???
Great Explanation!!!
Great video, thanks!
If you add country to the filter pane or as a slicer, would the Python visual interact with the selection made in the filter?
I just have a question. Are data slicers working with these visualizations?
Thanks for your useful video. Does the script editor have function or variables suggestions? Therefore we can avoid the typing mistakes. Thanks again!
Thank you for the demonstration! Quick question, could I output a data set from the Python script? For example, if I load the fields in the same way you did, could I then process the data and generate an tabular data out of it? Many thanks, just subscribed!
Very good video. Thanks to you
NICELY done...
Thanks Mark!
Please do make more videos of python with powerbi.
Really been meaning to! Hopefully my schedule frees up a bit and gives me some time to explore some cool Python topics
brother how did you got that data
nice tutorial. Show how simple python can be.
HEJ. Is it possible to bypass the line "remove duplicates rows", sometimes in some cases it may iterfere? if somebody knows how to do it please share. THX
Try Creating an Index Column to the dataset.
Thankyou bro -- Just keen to see if you could re-establish the link to the data source?
I had the same problem, but when I heard the "drinks dataset" mentioned, I started searching the internet.
You can find the data at: www.kaggle.com/navneethc/drinks. To download the dataset you do need an account.
thank you, very good and useful tutorial!
Hey was wondering why py -m pip install pandas
Can we just write pip install pandas? What is the py -m for?
Great video, still relevant after an year. I just had a small doubt though. Is it possible to add data labels to the plots or make them available with a mouseover action
Hi Bikram, unfortunately the Python visuals don't allow any interactivity. You also can't use Plotly.
I am trying to uncompressed a column in a dataset using pandas and lzstring. I have used this syntax but the Python script errors with TypeError: 'function' object is not subscriptable
# 'dataset' holds the input data for this script
import pandas as pd
import lzstring as lz
df = pd.DataFrame(dataset)
df['DecompreseedAssets'] = lz._decompress['MigratedAssets']
MigratedAssets column has data that is compressed using lzstring
Could you help please?
Hi, can you make the violinplot interactive like the standard one in PowerBI? I mean so you can mouse over it to get info on median, average and so on..?
With Plotly, yes! Though I don’t have a video on it.
@@BIElite Nice! Could you make one of those? 😁 I appreciate you sharing your knowledge - its really helpful!
Can we create visuals with custom images?
I have an error: python visuals are currently disable in your organization!!!! so, is python scripts only visible on the Microsoft cloud? and don't visible on the report server?
Can you slice and dice the visuals powered by PBI ?
thanks
Good vid man!
Thanks Bruce!
Do you know if it is possible to use python visualisations in the report server?
I have an error, why so?
Is there a way we can have the sample data tied to it for trying the examples. Appreciate it.
A Great Video!
Lets take an example I have 100 vines so how can I insert scroller in Visual
This is fantastic. Are there other visualizers other than matplotlib that you know work really well with PowerBI?
Hey Joshua, a couple others (besides matplotlib and seaborn) that I use are ggplot and geoplotlib. I haven't tried them in Power BI yet but will be soon. I assume that plotly will not work natively in a Python Visual as it doesn't in an R visual, but that might be something to try out
Bokeh is another python rendering engine I use
Keep up the good work!
Power bi with python will be great compare to power bi with SQL? Please reply
thanks dude!!!
No problem!
Can slice and dice these R and Python visuals with filters and all??
Can we create 3d charts using python ?
Hello... Thanks for the video. I however have a question regarding Python and Power BI visuals. I hope that you can give me some lights on how to go through the solution. I believe that you are aware about the Narrative Visual that convert any graph to a narrative. I'm looking for a way using Python (or else - I prefer Python) to take control over that Narrative Visual and pass the narrative text in a variable converting it to Audio and play it in another Python Visual. Is it possible ? if yes how ?
Thanks
+ahmed elbdrawy coming soon!
Hi.
Any suggestion to fix this?
community.powerbi.com/t5/Issues/Bug-in-python-visual/idi-p/487259
The issue seems to be the comma "," as decimal separator
+Fabián Álvarez I just took a look at the issue and I don't have an idea how to fix it, sorry. I imagine that's a locale problem that Microsoft will need to fix in the future. Sorry for your trouble 🙁
@@BIElite Yes, I believe that too. I'll be patient and wait for a fix from Microsoft. Thank you for your support. 👍🏼
When will PBI introduce interactive visual by R or Python packages ?
Not sure that this is in the plans any time soon. R visuals have been out for years without interactive visuals being released. You can make your own interactive R visuals by creating a custom visual, but this isn't supported with Python yet I believe.
Thanks for this wonderful video.... How to export Entire Page ( with visual ) into csv file Can you please explain Me. (Using Python or R scripting )
Can we create a python script that will change the output depending on the filters we choose in the filters selection?
No, Python wont work that way. You need to use DAX.
This is a fascinating work through. Thank you for that.
But in the power BI web, how to make the python related visuals and script working ? Hope you can make another video on that topic. Thanks.
+ynwtint I don't think the visuals are supported yet. You can run Python scripts if you are connected to a personal gateway. I haven't tried this yet but I am planning to. I'm hoping that Python becomes generally available in this month's update
Great videos and very easy to follow. Keep up the great work!!! Can we create custom visuals using Python in Power BI ?
Thanks for the compliment Nama! I think you can create Python custom visuals. That's an assumption though. I have been thinking about creating a Plotly custom visual when I get the time
I'm getting syntax error on pandas.Dataframe()
love this, thank you. Is there a tool to make dinamic visualiztion? I mean, can I get a input from power bi to my python script?
+Carlo Ezra Martinez Ruiz yes to a degree! You can write a python script inside of a Python visual which will make the code execute every time there is a slicer or visual change. It's pretty handy
Interactive calls in the Python script, such as waiting for user input, halts the script’s execution. Refer: docs.microsoft.com/en-us/power-bi/desktop-python-scripts
If you add slicers in powerbi would Python take the filtered dataset into account?
Yep, sure would!
Awesome...
Great! Where I find documentation of these functions?
I hope it’s not to late, but you can find seaborn and matplot lib galleries online. I really like to browse through them to search what I need for every specific case.
@@dianamgdata Thanks Diana!
Hi, Thanks for great video. I am getting DLL load fail error, any idea on how to solve it?
Hi! Have you solve it?
Nice video. Can we import numpy too?
Thanks ashish. Yes, definitely. You can import whichever packages you want
can plz create the bubble chart using python
+Aswini jagdale bubble charts can be built with the default scatter chart or with a custom visual. Python might be more challenging to accomplish.
Cool!!!
Interesting
Definitely!
10:00 everything reminds me of her...
They're not exactly attractive nor interactive though. Fail to see the benefit.