Forum Discussion

V55's avatar
V55
Icon for Helper I rankHelper I
7 years ago
Solved

How does List.Generate work? Will it consume memory for intermediate table data?

Hi,   I am trying to fetch data from Log Analytics from powerBI using Log analytics RestAPI.   The API has limitation of 500000 rows per query.  And hence I am thinking of handling large dataset...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    V55 ,

    >>My objective is I would like to avoid any heavy operation (in terms of memory due to 1GB dataset limitation) performed at powerBI

     

    There is no data volume limitation for a load for either DirectQuery or Import. We will meet the limitation for dataset when we publish a pbix file over 1GB to Power BI Service.

     

    When Power Query run the above query, it will actually takes more memory, but after the data imported into dataset, Power Query will release this part of memory. The memory used by Power Query will also not affect the size of dataset.

     

    Generally, to make a small pbix file and improve performance in Power BI report, please follow the guide in this article to load data and optimize report.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

V55 ,

>>My objective is I would like to avoid any heavy operation (in terms of memory due to 1GB dataset limitation) performed at powerBI

 

There is no data volume limitation for a load for either DirectQuery or Import. We will meet the limitation for dataset when we publish a pbix file over 1GB to Power BI Service.

 

When Power Query run the above query, it will actually takes more memory, but after the data imported into dataset, Power Query will release this part of memory. The memory used by Power Query will also not affect the size of dataset.

 

Generally, to make a small pbix file and improve performance in Power BI report, please follow the guide in this article to load data and optimize report.

Regards,
Lydia