Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to import a full database from a Windows 2003 Server 32 bits enviroment with SQL Server 2008 32 bits.
Using PBI desktop (configured with 8GB memory) I start importing a full database and after 2 hours I got following error message.
It is in spanish but tells there is a table with too much columns and operation is cancelled because is an out of memory issue.
Spanish
La carga se canceló debido a un error al cargar una tabla anterior.
No se pudieron importar los datos en el modelo. La causa podría ser el gran número de columnas de 't_volcado_rotacion_2'. Trate de reducir el número de columnas antes de volver a cargar.
Microsoft.AnalysisServices.OperationException: No se han podido guardar las modificaciones en el servidor. Error devuelto: 'La operación se ha cancelado porque no hay suficiente memoria disponible para la aplicación. Si usa una versión de 32 bits del producto, considere actualizar a la versión de 64 bits o incrementar la cantidad de memoria disponible en el equipo.
'.
at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveOptions saveOptions)
at Microsoft.PowerBI.Modeler.ModelManager.SetDataType(Table table, ColumnInfo columnInfo, Boolean clearTableValues)
at Microsoft.PowerBI.Modeler.ColumnSubsystem.CreateColumn(Table table, ColumnInfo columnInfo)
at Microsoft.PowerBI.Modeler.ModelManager.CreateColumn(String tableName, ColumnInfo columnInfo)
at Microsoft.PowerBI.Modeler.ModelManager.CreateTable(String tableName, String datasourceConnectionString, String datasourceCommandText, List`1 columns, Boolean usesOdbcQuery)
at Microsoft.PowerBI.Client.Windows.Modeling.SchemaChangeApplier.Visit(NewTableSchemaChange schemaChange)
at Microsoft.PowerBI.Client.Windows.Modeling.SchemaChangeApplier.Apply(IModelManager modelManager, IEnumerable`1 changes)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.<>c__DisplayClass13.<ExecuteChange>b__12()
at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringExceptionHandler.AddModelChangeResultToExceptions(Action action, ModelChangeResult modelChangeResult)
Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.ExecuteChange(ModelChange modelChange)
Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelSchemaSynchronizer.ApplyQuerySchemaToModel(IAnalysisServicesLoadContext loadContext, IEnumerable`1 loadInputs, IExtendedModelChangeScope modelChangeScope)
Hi @dpombal,
As suggested in the message, you may need to increase the amount of memory available on the computer, or try to reduce the number of columns(remove unnecessary columns) before reloading.
Or you can try connecting to your SQL database with DirectQuery mode on Power BI Desktop if possible.
Regards
Is it possible to import more than 1 million records I have approximately 4 million SQL records to Power BI?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |