Not all records showing up in visual

[guyd]

Hi,

I havent' had the following problem in the past (with more complex queries).

Therefore to isolate the problem I just created a simple query (selecting a table nothing more), all rows/records (in the db) show up in the Power Query Editor preview pane. However, when using a table visual I only get part of the recordset (14 rows/records)!

My database is an Azure SQL db with Direct Query. Neither on Power BI Desktop nor in Power BI Service I get all records.

Probably I oversee something?

Thanks.

[v-chuncz-msft · Accepted solution]

@guyd,

You may check if there is any filter.

https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter

[guyd]

As far as I can see I haven't any filters. To be sure I created a new PBI Desktop report. Only selecting 1 table from my Azure SQL db.

In my Azure DB Tabke I have 86 records and in my PBI report 54 rows (at this moment)!?

Thanks.

[guyd]

Everything is working fine now.