Report with Live Connection does not populate details correctly

[Anonymous]

Hello, 

I have created a report using a direct query (live connection) to the Netezza database. The report has a summary table and multiple tables for showing the details. 

When I click on a record from the summary table, the data in other tables (details table) gets updated only for certain records. For example if the summary table has 10 records, the details for only 4 correpoding records get updated in detail tables. For other 6 records when I click on them (Individually) in the summary table, blanks appear in all of the detail tables. 

The report pulls the data only from one table in Netezza and when checked, the details exist for those 6 records in the Netezza table. I need to populate the details for those 6 records too. 

Any advice, suggestions? 

Thanks, 
Jash

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

It seems you may click 'Refresh' to check again.If it is not your case,you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Regards,

[Anonymous]

Thanks @v-cherch-msft , I have created the support ticket.