Power Bi Storage

[Anonymous]

I am not able to see the data in transform also because without see the data in query editor how can i create a any parameter or drop the unessery data in table. I'm getting this error in power bi when i have just connect the power bi to data set. @PowerBI @PowerbiQue @query 

[Anonymous]

Hi @Anonymous ，
Thank you for your reply, Storage here refers to the size of your computer's memory. You'll need enough of your RAM to get power bi running to process this data.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Which type of storage are you referring to? Are you talking about a database, Power BI storage, or laptop storage (VM)?

I am having trouble loading or viewing data in Power BI. I can only see the table names. When I select a particular table, I encounter an error. This issue is specific to one table; I am able to load data from other tables successfully in Power BI.

System info:

Processor          Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz   2.79 GHz

Installed RAM   48.0 GB

System type      64-bit operating system, x64-based processor

Pen and touch  Pen and touch support with 10 touch points

Edition Windows Server 2022 Datacenter

Version 21H2

[Anonymous]

Hi @Anonymous ，
Based on the error messages you provide, you do not have enough memory on your system for Power BI to be able to work correctly.

You may need to install additional memory onto your system where you have Power BI Desktop installed, or if you have another PC or laptop with additional memory to use that.

And you can try to remove some of the filters and try again to see if you can refresh it successfully.

For more information you can refer to the following documents
Solved: OLE DB or ODBC error: evaluation ran out of memory... - Microsoft Fabric Community
For more information on how to use parameters in power query and reduce data model size, you can check out these two pieces of documentation
Parameters - Power Query | Microsoft Learn
Data reduction techniques for Import modeling - Power BI | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Hi @Anonymous 

Which type of storage are you referring to? Are you talking about a database, Power BI storage, or laptop storage (VM)?

I am having trouble loading or viewing data in Power BI. I can only see the table names. When I select a particular table, I encounter an error. This issue is specific to one table; I am able to load data from other tables successfully in Power BI.

System info:

Processor          Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz   2.79 GHz

Installed RAM   48.0 GB

System type      64-bit operating system, x64-based processor

Pen and touch  Pen and touch support with 10 touch points

Edition Windows Server 2022 Datacenter

Version 21H2