Forum Discussion
After connect dataflow to PowerBI Desktop some values changes to 0
Hi all,
i have annoying issue - when I organise the data in dataflow at the final step of preparation I see the data in dataflow is fine, but when I connect that dataflow to the powerbi desktop, some data turns to zeros at the very first step. I don't understand why? Maybe someone else has encountered this problem?
Data in dataflow
Same data after connect to PBD:
Something magical was happened
I have just updated the formulas, stretched them again and all the mapping is back to normal
So I don't know what was going on here \_o.O_/
6 Replies
- Kishore_KVN
Solution Sage
Hello DanielFdrvc ,
This is because in dataflow might be considering different region for date format and your local machine is of different region. So to align it either you can use using local option in the power query editor transformation of the table in dataflow.
Refer below video for details:
25 - Using Locale to Manage Dates in Power Query - YouTube
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Hi, but problem isnt with dates
I see correct dates, problem is with other values 😞
Hi DanielFdrvc ,
Are you the owner of the data flow? From the picture, it looks like this column in the data flow is of text type, try converting it to a number type in the data flow, then save and refresh it.Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Something magical was happened
I have just updated the formulas, stretched them again and all the mapping is back to normal
So I don't know what was going on here \_o.O_/
Yes I am the owner and yes in the dataflow itself the numbers are changed to a text type, but the problem only occurs with those few entries for 2024. Previous years' numbers:
- which are in the same column
- and whose type is also text
- and they are also displayed in the last step of dataflow modification
- and connected to the PowerBi desktop show up fine,but only the entries for 2024 are converted to zero in the PBI Desktop application.
The source of the 2024 numbers are the same formulas as 2023/2022/2021 etc., nothing has changed, but 2024 numbers converts to zeros 🙂
