Solved: Can you use Analysis Services and another data sou...

DebbieE · ‎07-02-2019

A User just asked me this question. If you have a report linked to analysis services and you want to Add some more data to the model, say from an xls spreadsheet, can you simply add that data? They basically just want to be sure you can work with more than just analysis services in the one data set for the report.

MattAllington · ‎07-02-2019

If you are using a live connection to AS, then no, not yet. I guess it may come.

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

v-piga-msft · ‎07-10-2019

Hi @DebbieE ,

It seems that you want to know if we could add another data source in the power bi report when we have connected with SSAS.

As MattAllington said, if you use connect live mode, we cannot add another data source, if you use Import mode, we could add another data source.

Best Regards,

Cherry

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