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.
Hello ,
Could you let me know which approach is batter and what is pros and cons between following two
1) Create SSAS tabular model which is refreshed periodiacally and use it as data source in Power BI using Direct Query method.
Here Power BI does not store data in it and will be used just as interface for reporting. Source will SSAS Tabular Model
2) Store Data in Power BI using Import Methode and refresh the data in Power BI periodically
Which method has more advantage and what are pros and cons in each method.
Can you please help me please
Thanks
Mahesh
Solved! Go to Solution.
Hi @MaheshDadhich,
Based on my research, here are the basics.
Import - extracts the data from your database and pulls it into the Power BI Desktop
Connect live – Creates a direct connect to your data. The speed of your data source will determine performance. Here that means making a direct connection from Power BI Desktop to your SSAS Tabular model.
Pros:
Import -
Connect live –
Cons:
Import –
Connect live –
For more details, please check the online document.
Regards,
Frank
Hi @MaheshDadhich,
Based on my research, here are the basics.
Import - extracts the data from your database and pulls it into the Power BI Desktop
Connect live – Creates a direct connect to your data. The speed of your data source will determine performance. Here that means making a direct connection from Power BI Desktop to your SSAS Tabular model.
Pros:
Import -
Connect live –
Cons:
Import –
Connect live –
For more details, please check the online document.
Regards,
Frank
Hi @MaheshDadhich,
Does that make sense? If so , could you please mark this answer as a solution?
Regards,
Frank
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |