Get Data from SQL Services and Other Flat File

[yassirkamil]

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 from SSAS, however to also include an external flat file that i just received from external party. How can i do this

[gipiluso]

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]

Hi @yassirkamil,

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

Regards,

Ruslan