Choosing a big data storage technology

[o59393]

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.

[v-yuaj-msft]

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.

[v-yuaj-msft · Accepted solution]

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 @v-yuaj-msft 

Can you share any link/video of the premium content to store my dataset?

Thanks!