cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
waterlikeair Frequent Visitor
Frequent Visitor

Power BI not showing data in table, but shows it filter

Hi,

I have a report I created that uses tickets numbers.  The ticket number shows up in the filter like it exists with a 1, but does not show up in the table at all. 

 

I have tried to disable and reenable the preview features, and refreshed the dataset & the dataflow.  This is happening with a lot of different tickets.  There are NO filters applied to this table in the queries, and the only filter applied is the ticket search number. 

 

I have tried looking in the data export to find the tickets and they do not exist in the export.

Not sure what to try next so any help is appreciated.ticketnotshowing.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
waterlikeair Frequent Visitor
Frequent Visitor

Re: Power BI not showing data in table, but shows it filter

The issue turned out to be an unknown error.  Putting the data in a new table fixed the issue.

3 REPLIES 3
waterlikeair Frequent Visitor
Frequent Visitor

Re: Power BI not showing data in table, but shows it filter

Bump

Cmcmahan New Contributor
New Contributor

Re: Power BI not showing data in table, but shows it filter

It may seem silly to ask, but does that ticket have values for the fields?

 

You may want to try the dropdowns for your values and select the option to "Show items with no data".

waterlikeair Frequent Visitor
Frequent Visitor

Re: Power BI not showing data in table, but shows it filter

The issue turned out to be an unknown error.  Putting the data in a new table fixed the issue.