Hi Hari. Thanks for reaching out... However my query is still not resolved. Actually we have our data source as SnowFlake tool.... So my data is available in various tables in it and Big Data team created a Non Materialistic VIEW to clubbed the data at one place and we are using that VIEW to call the data into Power BI in direct query mode. It gives an awfull performance in Power BI as just to load the data we have to wait for like 1 to 2 hrs. My data has 73 million records and growing. On checking found out that Power BI runs every column available in the VIEW as a seperate query and not as one... And this VIEW is called into Power BI for like 2 times as directed query and 1 time as Import Mode for every individual column of the VIEW... So when we open the report again created on VIEW it is running same SQL query for all the columns present in the VIEW individually and not as one. For ex. If I have 100 columns in the VIEW, the SQL query not run for 2 VIEW but for 200 columns... But the same is not the case when there is a Table. In Table the SQL query run as 1 only. Can anyone tell me why is it happening and how to resolve it?
