Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Icon for Post Prodigy rankPost Prodigy
10 years ago

Possible to use SSAS Tabular On Prem connection with Excel pivot table deployed to SP Online?

I understand that you can use Power BI to query back to on prem (or IaaS VMs) of SQL SSAS Tabular models.   Those will support security using the username of the user opening the model/connection. ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

So, what you are asking to do was basically how the old Power BI for O365 worked, not sure about that as a go forward strategy though as I am unclear what the path forward for that is. But basically, Power BI for O365 worked as you described although I am not sure it ever supported SSAS tabular as a refresh option, I believe it did but would have to go find the old documentation on data sources supported for data refresh.