Forum Discussion
Rows are empty when connecting with Desktop
This is my table in the dataflow, all the rows are full there are no null values.
And this is the table after i load it in the desktop, all rows turn into null values.
I don't know why this is happening to me knowing that it used to load well before.
I tried to connect with the table with the two modes import as well as direct query but same problem.
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
5 Replies
Is 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.Thats odd. Im going to see if im experiencing the same issue.
