What is the best way to get data on power bi dashboard

[_unknownuser_]

I have some data files sitting in azure gen2 storage in .csv and .parquet format
I also have the same data ingest to a SQL DW table.
Data size = ~50GB

What is the best and optimal way in terms of speed to display this data on a power bi dashboard.

1) I tried direct connection to SQL table, but it times out.
2) Shall I involve AAS ?

Also, if someone can clarify on authentication that I should opt for.

I hv some experience with Tableau, and there I used to move that data onto tableau server as a tableau data source, which allowed the tableau report to render quickly because upon every load, it had to just get data from tableau server and not from the original data source. Is there something in similar in Power BI world ?

[lbendlin]

Assuming you are doing this on a P3 or better I would suggest you use incremental refresh with bootstrapping.

Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Micr...