cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yael Member
Member

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: connecting data sources

Hi @Yael,

 

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

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Community Support Team
Community Support Team

Re: connecting data sources

Hi @Yael,

 

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

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Yael Member
Member

Re: connecting data sources

thanks @v-yulgu-msft. But about connecting live with Tabular? Can I use excel there too?

Community Support Team
Community Support Team

Re: connecting data sources

Hi @Yael,

 

If you mean SSAS Tabular model, yes, it is supported.

https://www.youtube.com/watch?v=Mtig3rmIUe0

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yael Member
Member

Re: connecting data sources

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?

Community Support Team
Community Support Team

Re: connecting data sources

Hi @Yael,

 

Yes.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.