Forum Discussion
po
Post Prodigy
Post ProdigySSAS datasource - does this involve reading/storing data twice?
Hi, currently import data from oracle + sql server databases into power bi. If were to uses ssas as a datasource my understanding is that this would involve reading/storing data twice - once ...
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi po ,
When you are using the SSAS, you could refer to using live connection mode, which would not import data to your pbix and make your data refresg fast, you may refer to below link:
https://powerbi.tips/2018/02/power-bi-connections-live-connection/
Regards,
Daniel He
poPost Prodigy
Post ProdigyHi,
Thanks for update though believe can use direct query with power bi.
Also, with imprt mode and SSAS as datasource, is it the case that the data woudl be imported twice?
Thanks