Data won't return for tab in anaylsis containing 100M+ rows

Question & Answer
,
1

I created an analysis with 5 table visuals that each Direct Query corresponding datasets. I created two parameters (Date and Trading Symbol) on each dataset that mapped for each visual. All visuals return data for the passed Date and Trading Symbol except one which contains 136M+ rows and 40 columns. Could this be related to the size of the dataset?

2

Hi @Ed_McCann

In all probability it may be the volume of data that may be causing this since you are using Direct Query.

Does the visual provide any indication of the problem?

Regards,
Giri

3

The visual ended up bringing back the entire dataset. We found the issue to be with the way the parameter was used in the query. After updating data is now returning.