Best Power BI Solution for Large Datasets

Hi Amit

Thanks for your reply. Though these links explain the overview and their differences but I have few further questions in relation to my challenge from these links:

1. Power BI Premium: It does allow upto 100GB datasets but this is only applicable to modelled, processed and compressed data (pbix files); hence this feature can only be helpful after deployment to Power BI Service.

For development in Power BI Desktop (on my local machine), Power BI Desktop would connect to Blob Storage and still would bring the data to my local machine for processing (blob storage only offers in-memory connection). Hence, using my machine's RAM which won't be able to handle processing larger datasets (in5 GBs). Please confirm if my understanding is incorrect here and if so, then how Power BI Premium would help with this local machie processing challange?

2. Azure Analysis Service: In this option, Visual Studio woud connect to Blob Storage to get data, model it and then deploy to AAS as cubes. When Power BI (even Pro) connects to AAS, it would be send the query to AAS cube to process, hence processing is done in AAS server now, instead of my machine. Also, AAS would offer scale out option to handle large size cubes. Hence, this option should not impact my local machine while using Power BI Desktop for processing the data.

I believe similar process would work for Azure Synapse Analytics (cloud DWH). If my assumption is correct, then can you please help me to select between AAS and ASA? 

Thanks