Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 to import into ssas then again to import the same ssas data into power bi.
From this perspective, not seeing any advanatges to using ssas over power bi datasets.
Could you confirm this would indeed involve double reading/storing and discussion of any advs of ssas over power bi datasets.
Thanks
Hi @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
Hi,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |