Forum Discussion
Post ProdigyChoosing a big data storage technology
Hi all
I have a dataset of over 100K rows in an excel. But I am trying to migrate it to a different data storage, I've used all the time Sharepoint lists, but this data amount collapses my SP list.
Which data storage option do you recommend to level up my capabilities? Any material is more than welcome.
Thanks community.
Hi o59393 ,
Have you tried to migrate your data to some databases? Just like SQL Sever database, Oracle database, PoestgreSQL database and so on. Or you can put your workspace into a Premium environment to storage your dataset. (limit to 10GB)
Please refer to the following links if they can help you.
Import data from Excel to SQL - SQL Server | Microsoft Docs
How do I import data from Excel to Oracle using SQL Developer? (findanyanswer.com)
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi o59393 ,
Have you tried to migrate your data to some databases? Just like SQL Sever database, Oracle database, PoestgreSQL database and so on. Or you can put your workspace into a Premium environment to storage your dataset. (limit to 10GB)
Please refer to the following links if they can help you.
Import data from Excel to SQL - SQL Server | Microsoft Docs
How do I import data from Excel to Oracle using SQL Developer? (findanyanswer.com)
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- o59393
Hi Anonymous
Can you share any link/video of the premium content to store my dataset?
Thanks!
Hi o59393 ,
Please refer to the following links.
Manage data storage in your workspaces - Power BI | Microsoft Docs
Large datasets in Power BI Premium - Power BI | Microsoft Docs
You can also try a new PPU license to store more larger datasets.
Power BI Premium Per User FAQ (preview) - Power BI | Microsoft Docs
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
