The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
When i use a python script as data source it changes some values, for example if i have a 1.0 when i load the DataFrame in power Bi it'll show me 10.
How can i make power Bi respect the data types from the original dataFrame?
Thanks for the help.
import numpy as np
import pandas as pd
df2 = pd.DataFrame(
{
"A": 1.0,
"B": pd.Timestamp("20130102"),
"C": pd.Series(1, index=list(range(4)), dtype="float32"),
"D": np.array([3] * 4, dtype="int32"),
"E": pd.Categorical(["test", "train", "test", "train"]),
"F": "foo",
}
)
Solved! Go to Solution.
@Anonymous , I ran the same script and I am getting 1.0 (only added pandas).
Check for any transformation in power query
Thanks.
That was the error, i had to chanege my regional configuration for one that used "." insted of "," to separete decimals.
Thanks.
That was the error, i had to chanege my regional configuration for one that used "." insted of "," to separete decimals.
User | Count |
---|---|
86 | |
84 | |
36 | |
34 | |
34 |
User | Count |
---|---|
93 | |
79 | |
66 | |
55 | |
52 |