Power BI - Best practice importing large amount of data

0

I'm new to the BI business, and I have to do BI for just over 25 million records.

Importing to Power BI is impractical, since the file would be over 1GB and would be impossible to post on the web. So I opted for DirectQuery. It's just that the loading of dashboards on the web is very slow.

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

Thank you very much.

    
asked by anonymous 28.12.2017 / 13:34

1 answer

0

If you know a little bit of the SqL language, you will be able to summarize a good part of the information. If you can not summarize, only import the columns that you will actually use in the panel. and work only with measures, they are faster.

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

Another important thing, is the error really happening for timeout? Have you tried uploading a panel with only 10 lines? I've already experienced a situation where my getway was not working properly.

    
28.12.2017 / 14:00