Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello, I'm having a strange situation with the Power BI.
I have dataset that is built in python, which is then exported into a spreadsheet. The Power BI then reads from the spreadsheet. For one particular column, if I create the column in python one way, it displays fine. However, I create it a different way, the visual in Power BI will show everything from that column as blank. The strange thing is that the column in the spread sheet, the preview in the Power BI query, and column in the Data section all show what is expected, and that there are values other than Blank. However, when I create the visualisation, it shows that the column has nothing but blanks. I've also verified with the corresponding filters.
Unfortunately the data is confidential so I will not be able to share screenshots. It's jut odd because I've created other columns in python with the same method and they don't have this issue.
Does anyone have any ideas what would cause this?
Proud to be a Super User!
Hi @ewong18 ,
Could you please try to create a calculated column using CalculatedColumn=TRIM([OriginColumn]) and then use the new column in a table visual ? What is the kind of Data Category of the origin column?
Best regards,
Hello,
Unfortunately, creating the new column with TRIM did not fix the issue.
Also, the Data Category is currently set to Uncategorized. The data wouldn't fall into any of the categories on the list.
Thank you
Would it be possible to share some screenshots of the PowerQuery screen in both cases? It is just guessing at this point without being able to see the data 🙂
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
146 | |
111 | |
109 | |
103 | |
96 |