Powerbi Datasets as a Datamart

[Anonymous]

Hello,

My name is Amari and we are trying to move from tableau to pwerBi. In tableau we create datasets on the tableau server that imports around 25 to 30 million rows of data in to a single data extract for our end users to build dashboards without wasting any time. Powerbi is having a rough time importing 5miliion rows in to a powerbi dataset. We use datasets to get our analysts closer to the data without knowing sql, so this crucial that we get this fixed because if not our teams can not move tools.

How do i solve for this issue? 

[rdnguyen]

@Anonymous  The update today release Datamart which would be able to let you import data into Datamart, instead of using Dataset. Check it out with helpful links below

Announcing public preview of datamart in Power BI | Microsoft Power BI Blog | Microsoft Power BI

Introduction to datamarts - Power BI | Microsoft Docs

Power BI Datamart Integration in the Power BI Ecosystem - Radacad

Exploring the preview of datamart in Power BI!

[v-easonf-msft]

Hi , @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason

[Anonymous]

no the problem has not been solved I would love to get on the phone and maybe screenshare with someone

[v-easonf-msft]

Hi, @Anonymous 

Dataflows are used to ingest, transform, integrate, and enrich big data by defining data source connections, ETL logic, refresh schedules, and more. 

If help ,pls refer to this documnent for more details.

service-dataflows-overview

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[camargos88]

Hi @Anonymous ,

Have you seen DataFlows ? Perhaps you could it to solve your problem.

https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use