cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tera12
Advocate I
Advocate I

Data Not Showing Up

Hello everyone,

 

I am having a very weird problem.  I have condensed my data down to 7 records (each record has multiple lines of data). I can see all the records in the Query Editor, but when I go to the visualization page, 1 of the records will not show up. All of the records have the same type of information, as well as some "Null" cells - and all the rest have all shown up perfectly.  

 

I isolated the one record, and again, I can see it in the Query Editor, but when I open it in "Modeling" the table is blank.

 

I have tried: Correcting errors and enabling "Show items with no data" - nothing works.

 

Any ideas?

 

What Shows in Query EditorWhat Shows in Query EditorWhat Shows in ModelingWhat Shows in Modeling

1 ACCEPTED SOLUTION

Dale,

 

Hello, thank you for checking in. I tried removing and importing new datasets, and for some reason that fixed the problem.   I had tried refreshing and closing and opening the document, but neither of those worked, so I just re-imported the datasets and that fixed it.  It was weird, but it is working now.

View solution in original post

10 REPLIES 10
ofarrera
New Member

Hi guys, I am running into a similar problem here. I tried to refresh my charts using Power Bi Desktop but when I tried I am gettting the following error plus no data is shown on the Data Query. I have tried all the things on this blog plus closing and reopening Power BI with no success. 

 

Here are the screen shots.  

 

Capture PowerBI1.JPGCapture PowerBI2.JPG

jwesle
Frequent Visitor

Hello,

 

I realize this is an old topic, but I am having a very similar issue and have been unable to figure it out.

 

Results from my query shows the following (only two records):

Query.PNG

 

The modeling data view shows only one record:

Model View.PNG

 

I have tried opening/closing, refreshing, creating a new query, disconnecting all relationships, and have assured there are no filters in the model. Does anyone know potential causes for this issue?

 

Thank you,

Jimmy

ashrachova
Regular Visitor

It can happen because someone has eliminated the refresh of this table from the general refresh. You can check/fix that by going to "Edit Queries", right clicking at the query and making sure the "Include in the report refresh" option is selected. 

aar0n
Advocate II
Advocate II

I just had this issue, and the quickest/easiest way was to make a new "Blank" Query,  then go to the old query, click on "Advanced Editor", copy everything, then go back to the Blank Query, click on Advanced Editor, and paste. finally, delete the old query and click apply.

This worked for me 🙂

Glad to hear it! it was frustrating at first, and nothing else seemed to work for me. 

v-jiascu-msft
Microsoft
Microsoft

Hi @tera12,

 

Quite weird. How about refreshing? If refreshing can't solve it, could you please provide the file (pbix)? It's too hard to reproduce.

 

Another try: click the header of the columns.

 

Data Not Showing Up.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Dale,

 

Hello, thank you for checking in. I tried removing and importing new datasets, and for some reason that fixed the problem.   I had tried refreshing and closing and opening the document, but neither of those worked, so I just re-imported the datasets and that fixed it.  It was weird, but it is working now.

View solution in original post

dtartaglia
Resolver I
Resolver I

Hi,

 

I've seen that issue before. Seemed closing/reopening Power BI resoved it. I've seen weird issues like this when the data was being accessed over a VPN or my home network to work.

Hi Dtartaglia -  I was hopeful, but closing and opening the document didn't fix it.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors