Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hello guys,
I am working on a table in power query. As well, I am using python script from the transform tab. The problem I have occurs when I want to assign a value to a specific column and row in the dataset.
Here is an example:
| name | day |
| max | 1 |
| alfred | 2 |
If I want to change the values of the "day" column, I do this:
dataset.iloc[0]["day"] = 0
dataset.iloc[1]["day"] = 0
When Power Query execute the python script, the table didn't change.
Any help?
Thank you!!
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 3 |