Chihiro
Excel Ninja
Woot!
They've added Preview feature integrating Python into PowerBi.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/#python
Very simple sample script.
Result:
You can also use it in Query Editor and Visuals.
They've added Preview feature integrating Python into PowerBi.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/#python
Very simple sample script.
Code:
import numpy as np
import pandas as pd
data = np.array([['','Col1','Col2'],
['Row1',1,2],
['Row2',3,4]])
df = pd.DataFrame(data=data[1:,1:],
index=data[1:,0],
columns=data[0,1:])
Result:
You can also use it in Query Editor and Visuals.