Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Power BI memory limit

I am using a laptop with 8 GB of ram. I am getting an memory error after loading 1,47GB of data from multiple excel tables into a appended table. What can I do to solve this?   Can I use the servic...
Need Help
Show and Tell
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Anonymous,

     

    Currently, there is no restriction on how large a pbix file can be locally. However, when you publish a pbix file over 1GB to Power BI Service, you will get a file size limit message. And in the case that your pbix file is less than 1GB when importing it to Power BI service, but the data model grows beyond 1 GB after a period of time, you will get a message when refreshing the dataset. 

     

    So you connect to your onedrive excel on Power BI services.

    How can I change the source of a excel file from my local folder to my onedrive folder? I don't want to rebuild the report all over again.
    Currently, we cannot change the datasource from local excel to the excel files that stored in onedrive. I am afraid you need to recreate the reports.

     

    If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
    https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

    Thank you for your understanding.

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Anonymous,

 

Currently, there is no restriction on how large a pbix file can be locally. However, when you publish a pbix file over 1GB to Power BI Service, you will get a file size limit message. And in the case that your pbix file is less than 1GB when importing it to Power BI service, but the data model grows beyond 1 GB after a period of time, you will get a message when refreshing the dataset. 

 

So you connect to your onedrive excel on Power BI services.

How can I change the source of a excel file from my local folder to my onedrive folder? I don't want to rebuild the report all over again.
Currently, we cannot change the datasource from local excel to the excel files that stored in onedrive. I am afraid you need to recreate the reports.

 

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Thank you for your understanding.

 

Regards,

Charlie Liao

chfio's avatar
chfio
Regular Visitor
8 years ago

Is this still not possible. I think i've edited souce via advenced query editor to shift from local to onedrive