Forum Discussion
Better database option for bigger data for PowerBI
Hi JustinDoh1 ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Deku for the prompt response.
As mentioned by Deku , you can use data warehouse and lakehouse in Microsoft Fabrics.
You can start with F2 or F4 capacities, and auto-pause and resume features save money during low activity.
Migrate reporting datasets to Fabric Warehouse or Lakehouse.
I recommend reviewing the documentation below:
https://learn.microsoft.com/en-us/fabric/data-warehouse/
https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-overview
https://learn.microsoft.com/en-us/fabric/data-warehouse/data-warehousing
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
Hi JustinDoh1 ,
Microsoft typically offers a free trial that provides access to the services, including features for data storage, processing, and analytics. The free trial gives you a certain amount of capacity, allowing you to explore and test out various features without incurring any costs upfront
You can check the fabric capacity pricing below . You can start with F2 capacity for doing more analysis if required.
https://azure.microsoft.com/en-us/pricing/details/microsoft-fabric/
A data warehouse is ideal for structured, cleaned data where fast queries and analytics are needed.
A data lakehouse is better when you want to mix raw and structured data for large-scale analytics.If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
v-sathmakuri Thank you for your reply. I am still trying to learn what other options are there.
I hear "Fabric" all the time, and I am not sure how our group can get started if needed.
Don't we have to pay extra money to get started?
Ideally, start up cost and other set up costs should make sense with better performance.
What is most common way to do this? Fabric Warehouse or Lakehouse?
Sorry, I am so new to this.
Hi JustinDoh1 ,
Microsoft typically offers a free trial that provides access to the services, including features for data storage, processing, and analytics. The free trial gives you a certain amount of capacity, allowing you to explore and test out various features without incurring any costs upfront
You can check the fabric capacity pricing below . You can start with F2 capacity for doing more analysis if required.
https://azure.microsoft.com/en-us/pricing/details/microsoft-fabric/
A data warehouse is ideal for structured, cleaned data where fast queries and analytics are needed.
A data lakehouse is better when you want to mix raw and structured data for large-scale analytics.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!