-1

I have a cube in SQL Server Analysis Services (SSAS) and I would like to be able to load the data that I have in an Excel file in the cube, is it possible to connect it?

Dale K
  • 25,246
  • 15
  • 42
  • 71
Johan C
  • 29
  • 6

1 Answers1

0

Create a data source : enter image description here

Create a database based on a new connection :

enter image description here

Choose the right provider ACE 14 OLE DB provider, you can check here to have an idea on data providers :

enter image description here

Amira Bedhiafi
  • 8,088
  • 6
  • 24
  • 60