Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |