Forum Discussion
Data Capacity
hi, i have a sql view with size of 16000MB, i have abput 4 duplicates of this view in the .pbix file in order to deal with complex data & business. is it too big fot power BI to deal with? my compu...
I don't have too much information about your setup so I assumed that in your query you might be using the following Access Data Functions
- Odbc.DataSource might be able to define Connection Timeout in the connection string
- OleDb.DataSource no you Connection Timeout in the connection string
- Sql.Database (most likely) Whcih has the following option: CommandTimeout : A duration which controls how long the server-side query is allowed to run before it is canceled. The default value is ten minutes
Table.Buffer Buffers a table into memory, isolating it from external changes during evaluation.
Table.Combine Returns a table that is the result of merging a list of tables. The tables must all have the same row type structure.
If you don't have too many trade secrets in your M queries to get more precise suggestions.
