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

2 Replies

  • 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