Data not Showing up

[cclark01]

Hi Everyone - Hoping someone can help.

I have been having an issue lately with my data not showing up after I apply changes in the Queryt Editor.

The data will be there to start with, but if I "Enable Load" then decide later that I do in fact need that table to load in, so select Enable Load again, the data does not show up.  It loads in the Column names, but it appears as if the tables are empty. Has anyone else had an issue like this?  Am I missing something simple?

Thanks for the help!

[jodackson]

I need a solution for this!! help

[Ralfonso88]

Hi Rubioju! How did you solve this problem? It's happening exactly the same to me...

Thanks in advance and kind regards

[Jo_David]

Was it sovled, I am facing this exact problem as well. I reloaded, have no errors, disabled any and all preview features but nothing

[jaleman]

It happened to me, Power Bi Desktop was trying to connect to a database on the Gateway using local credentials.

In order to solve it, you have to define which credentials to use to connect to the database.

Make sure that the credentials being use or the MS Account being use has permissions to access the Database.

[Anonymous]

@cclark01 , i am facing the same problem, i tried with all the solutions mentioned here it still not working, can you please suggest me what to do 

[PurpleBlonde]

Jack did you ever find a solution for the data that wouldn't appear correclty in Power BI? I'm having same problem and none of the fixes work

[yakamoz007]

I have had the same problem. BI is loading data in the table but you see empty row. When you filter the empty rows in your column out you will see data. Bi is loading your table with the empty rows in excel. I don't know why.

I deleted all the whole empty rows in my excel table (not the data) from top to bottom. Then I actualised my table and then Bi shows me the data in my query editor!

So you can filter your column in the query editor or you delete the empty rows.

Try this: Here in the picture: Deleting all rows after my data

Or try this: Deselect the empty rows in the column filter.

I find this out and it works.

[Anonymous]

thanks for sharing this. it's worked out for me. 

[sudheerbolla]

This worked out