Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0

Limit on imported rows from analysis?

We are importing rows from datasets using the analysis server connection. The import can be to other datasets or dataflows.

This has been working fine until today. Now, all of a sudden, we are getting an error message saying: Error: Data Source Error : DataSource.Error: AnalysisServices: The maximum number of rows (5000000) was reached.

Has Microsoft implemented a limit on how many rows you can import from a table?

All our dataflows or datasets resides on premium workspaces.

Status: Delivered

Thank you for sharing, for other users with similar experiences you can check the comments below. This thread will now be closed.

 

Best regards.
Community Support Team_ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @Anonymous ,

 

Considering this huge amount of data, have you considered using Live connect mode to see if this error still occurs?

 

Data sources for the Power BI service - Power BI | Microsoft Learn

 

 

Best regards.
Community Support Team_ Caitlyn

Anonymous
Not applicable

Thank you for your suggestion Caitlyn. But we managed to find a solution to the problem.

This was probably caused by this change:

Analysis Services server properties in Power BI Premium are now in general availability | Microsoft ...

We checked the settings for the affected workspaces and indeed we found a value of 5 milion for one of the settings. Changing this to a higher value, using SSMS, the issue disappeared.

 

KjellG_0-1679383714186.png

 

Kind regards

Kjell

v-xiaoyan-msft
Community Support
Status changed to: Delivered

Thank you for sharing, for other users with similar experiences you can check the comments below. This thread will now be closed.

 

Best regards.
Community Support Team_ Caitlyn