Forum Discussion
Rows are empty when connecting with Desktop
Until now i still didn't find a real working solution for this problem but i found a workaround.
apparently there's another column other than these ones that i'm concerned about and wich contains some blank cells that cause all this mess.
When i tried to filter and get rid of them problem wasn't fixed.
The only thing that worked for me is to replace them with NULL value ( not null cause that doesn't work) but NULL so they'll be treated as if they're full and not empty.
Definitely consider checking this blog cause it has some useful informations Power BI dataflows considerations – XXL BI
Until now i still didn't find a real working solution for this problem but i found a workaround.
apparently there's another column other than these ones that i'm concerned about and wich contains some blank cells that cause all this mess.
When i tried to filter and get rid of them problem wasn't fixed.
The only thing that worked for me is to replace them with NULL value ( not null cause that doesn't work) but NULL so they'll be treated as if they're full and not empty.
Definitely consider checking this blog cause it has some useful informations Power BI dataflows considerations – XXL BI
Super UserThanks for the update. NULL/null/null/blank/BLANK/""/whitespace are my mortal enemies.