cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dpombal Member
Member

Error on SQL Server 2008 full database import on PBI Desktop

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)


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2 REPLIES 2
v-ljerr-msft Super Contributor
Super Contributor

Re: Error on SQL Server 2008 full database import on PBI Desktop

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.Smiley Happy

 

Regards

Jancarlos_Ascen Regular Visitor
Regular Visitor

Re: Error on SQL Server 2008 full database import on PBI Desktop

 
Is it possible to import more than 1 million records I have approximately 4 million SQL records to Power BI?

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 145 members 1,702 guests
Please welcome our newest community members: