Is there any data limitaion with Power BI Dataflow Gen1

[Koritala]

Hi,

I want to know is there any data limitaion with Power BI Dataflow Gen1? if yes, what is the limitaion.

I was trying to load the large table data from Redshift db and it is showing memory issue. Is there any alternate to consume the large tables in power bi dataflows.

Thanks,

Srini

[v-menakakota]

Hi @Koritala  ,

Thanks for reaching out to the Microsoft fabric community forum. 

Please go through the below link which may help you in resolving the issue:
Solved: Concurrent Dataflow limits. Premium vs Pro - Microsoft Fabric Community

Can you please confirm whether you are using premium or pro license?
 
Best Regards, 
Community Support Team 

[v-menakakota]

Hi @Koritala ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Thank you.

[v-menakakota]

Hi @Koritala ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Thank you.

[v-menakakota]

Hi @Koritala ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Thank you.

[AlexTheGreat]

Hi,

Gen1 has indeed some memory and resource limitations. 

The large dataset is probably completely loaded at once into the power query and because of the limitations you could receive errors.

What you could do (really depending on your situation) is use a gen2 dataflow, these are way and way faster.
Or use a DirectQuery or Import to avoid such problems.

Hope it helps!

[Koritala]

Hi Alex,

How can we choose import or direct mode for data flow? Usually it will not popup the option when you use data flow.

Thanks 

Srini

[AlexTheGreat · Accepted solution]

You cannot... dataflow doesn't support it 😞
A dataflow is always using import.

To use directquery you select your database (Home --> Get data --> More --> Redshift)  
And when you use confirm you can choose for directquery. 

Hope it helps!