Forum Discussion

yassirkamil's avatar
yassirkamil
Regular Visitor
8 years ago

Get Data from SQL Services and Other Flat File

Hi team,   Does anyone knows how to allow connection from SQL Server Analysis Services databases as well as an external flat file in Power BI?   Scenario: Currently, im accessing existing data f...
gipiluso's avatar
gipiluso
Resolver II
8 years ago

If you are going in Live Connection to SSAS you cannot add an excel as additional Data Source.

I think you have only two way:

  1. Import the excel on SSAS:
  2. use the SSAS in import mode (i didn't suggest, you will lost the benefit of it):

     

 

GP

 

zoloturu's avatar
zoloturu
Memorable Member
8 years ago

Hi yassirkamil,

 

Did you checked options provided by gipiluso? Do you have any questions?

 

Regards,

Ruslan