Power BI - Best practice importing large amount of data

Question

I’m new to the ID business, and I have to do the ID of just over 25 million records.

The import to Power BI is not feasible, since the file would be more than 1gb and it would be impossible to post it on the web. So I went with Directquery. Only the loading of dashboards on the web are too slow.

I would like to know what is the best practice for importing large amounts of data into Power Bi. If it is with Directquery (even taking a long time to load the dashboards and often not even loading because of Timeout), with Analysis Service or other type of import.

Thank you very much.

Answer 1

If you know a little of the Sql language you could summarize a lot of the information. If it is not possible to summarize, only import the columns you will actually use in the panel. and work only with measurements, they are faster.

Also check how are the data structures you are using. It may be possible to create an index in the bank to speed up queries.

Another important thing, is the error really happening by timeout? Have you tried climbing a panel with only 10 lines? Already happened to me a situation where my getway was not working properly.