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.
@Anonymous I agree with @ankitpatira, otherwise you could try out the new Analysis Services Tabular in Azure. It's a new (PaaS) Platform as a Service in preview. Details here
@Anonymous For that much amount of data I won't suggest you importing it and then refreshing. Instead user DirectQuery feature which would be much more faster and you don't need to worry about setting up gateway or anything since db is in azure.
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.