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
Super UserIs it a new dataflow that you just created? Can you try refreshing your dataflow in power bi service? and then load them in power bi desktop.
No it's not new and used to work well before.
I've already refreshed it multiple times, tried even to edit some queries.
What i find even weirder is that out of the 4 columns that show all null value, there's one that after i filter on it i start to see data as i should.
Tried to do the same with rest but still they only contain null.- Tutu_in_YYC
Thats odd. Im going to see if im experiencing the same issue.
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