Records not visible in table visualization

[JanKolo]

hi,

I'm reading data directly from SQL Server 2012 into a table visualization. In total there's around 340000 records. The problem I'm having is that not all of the data is visible, although it is there in the table.

I've used one key to filter to a set of particular records and it's not showing them. However, I know that it filtered correctly, as when looking into another filter I see that it's available values have been adjusted to exactly the number of rows I expect in this set of data.I hope this is understandable, but if not I can provide an example.

Is there some kind of limitation on the number of records PBD is loading into the table visualization? Or am I missing something?

thanks,

Jan

[asocorro]

Perhaps a table is not the best visualization option and maybe you should consider another tool for generating such a report.  For me, PBI is for high-level data analysis and presentation, not for detailed-record evaluation, especially for such a large number of rows.

[JanKolo]

I agree, it's not the best visualization for 340000 records. However, that's just the data source, which I filter to ca. 300 records to be shown in a chart. The problem showed up when I tried to verify those 300 records by loading them into a table visualization and couldn't see the records.

I want users to be able to see a chart with 300 records, and also be able to export those records non-summarized to CSV. Right now they can see them in the chart, but not in a table and I don't get why.

I can see those data if I press "See Records", but not if I change that pie chart to a table and show the non-summarized 300 records.

[Vicky_Song]

@JanKolo, I tried but failed to reproduce your issue. How about you scroll down the scrollbar? More data is loaded when I scroll down the scrollbar. If you always have this problem, it is better if you can show me one sample PBIX file. BTW, what is the version number of your Power BI Desktop?

[JanKolo]

hi Vicky_Song,

thanks for taking a look. I still have the same issue and I'm happy to share the pbix file however, I wouldn't want to upload it publically here. Can I send it by private message, or email to you?

Just to show on screenshots. As you can see I have a table, where the records count up to ca 340k and I want to apply filters to actually show only 300-900 records.

However, after applying the first filter on the RegionCode (= MRK), what should already limit me to 995 records, I get an empty table:

[Vicky_Song]

@JanKolo, it is better if you can provide me one pbix file with which I can check what's wrong with your report file. You can send it via email (visong at microsoft dot com).

[Anonymous]

Hi All

I am getting the same issue,for SQL tables not visible in Power BI Navigator. 

SQL TablesPower BI Navigator

I am considering two tables from SQL ,the tables names are KRONUS UK Ltd_$Customer and KRONUS UK Ltd_$Cust_ Ledger Entry. I am trying to Get Data from Power BI for Desktop and on Power BI Navigator i can't see the first table while the second table is visible two times. I am attaching the SQL and Power Bi Navigator both to make it more clear.