Forum Discussion

Yael's avatar
Yael
Icon for Helper IV rankHelper IV
8 years ago
Solved

connecting data sources

Hello, I'm connecting Live to Tabular model and using PBI. Is there a way I can add an excel as an additional data source and use both Tabular and Excel at the same report? Thnaks!
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Yael,

     

    With composite models, a report can seamlessly include data connections from more than one DirectQuery or import data connection, in any combination you choose.

     

    Best regards,

    Yuliana Gu

Yael's avatar
Yael
Icon for Helper IV rankHelper IV
8 years ago

thanks v-yulgu-msft. still not sure I understand - when connecting live to SSAS can I add an excel file also and create a report from both sources?

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Yael,

 

Yes.

 

Regards,

Yuliana Gu