Titanic dataset visuals with Python in Power BI

Hi all,

I try to import titanic dataset in Power BI, and make some basic Python visualisations.

In the query editor I can succelfully import the dataset using this Python code:

   import pandas as pd
   url = "http://biostat.mc.vanderbilt.edu/wiki/pub/Main/DataSets/titanic3.xls"
   titanic_df = pd.read_excel(url)
  

Then I load the data to the Power BI report, so I choose for a Phython visual type.

I want some basic visualisations using the Survived column, so I add column Survived in the values pane of the Phython visual type. Now I enter this code:

# dataset = pandas.DataFrame(age)

# dataset = dataset.drop_duplicates()

# Paste or type your script code here:

import numpy as np

import pandas as pd

import seaborn as sns

sns.set_style('whitegrid')

ax = sns.countplot(x='survived', data=titanic_df)

even with changing data=titanic_df to data=dataset I don't get a result.

I Jupyter notebooks this works fine. Python and the 3 packages (np,pd,sns) are installed on my machine and seem to work for other very small datasets (like a self constructed small dataframe of shape 2*2).

Anyone who knows how to do this? 

Thanks in advance!