Working with hundreds of millions

[Syndicate_Admin]

Hello tod@s,

I have a historical file in SQL with hundreds of millions of rows and I need to query four fields in that file.

It is necessary to consult the entire file because the traceability of a product has been needed for years (since 2017) to export the resulting table to excel with all the fields of that file.

I imported it with Direct Query but each query takes minutes.

Any idea how you could do this without it taking so long?

Thank you very much in advance.

[v-rongtiep-msft]

Hi @Syndicate_Admin ,

Reports based on a DirectQuery dataset can be optimized in many ways.

Please refer to the following document for detailed information.

https://docs.microsoft.com/en-us/power-bi/guidance/directquery-model-guidance#optimize-report-design...

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Polly

[Greg_Deckler]

@Syndicate_Admin Have you tried import mode?

[Syndicate_Admin]

Hello

I don't know if you mean importing the table of hundreds of gigabytes to the model?. Or do you tell me about something else? Thank you