Forum Discussion
couldn't load data for this visual - facing issue as shown in attached screen(we have 1700000record)
couldn't load data for this visual - facing issue as shown in attached screen(we have 1700000record in our table). can we know how this will be resolved.
Hi psathanapal ,
Thank you for reaching out to the Microsoft Fabric Community Forum.
The error message you are seeing is common when working in DirectQuery mode, as Power BI enforces a 1 million row limit per visual query in this mode. Since your dataset contains 1.7 million records, this exceeds the allowed threshold for rendering visuals.
As mentioned by FBergamaschi , switching to Import mode is the recommended solution. Import mode brings the data into the Power BI model, removing this row limitation and generally enhancing performance with large datasets.
If Import mode is not suitable due to requirements for real-time data or source constraints, you may consider these alternatives:
- Apply filters to limit the number of rows displayed in each visual.
- Aggregate your data to a higher level, such as by month or category.
- Leverage composite models to combine Import and DirectQuery where appropriate.
Hope this helps. Please reach out for further assistance.
Thank you.
5 Replies
- FBergamaschi
Super User
Are you in direct query? That's a limit for that connection type, would you consider changing it to import?
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi psathanapal ,
Thank you for reaching out to the Microsoft Fabric Community Forum.
The error message you are seeing is common when working in DirectQuery mode, as Power BI enforces a 1 million row limit per visual query in this mode. Since your dataset contains 1.7 million records, this exceeds the allowed threshold for rendering visuals.
As mentioned by FBergamaschi , switching to Import mode is the recommended solution. Import mode brings the data into the Power BI model, removing this row limitation and generally enhancing performance with large datasets.
If Import mode is not suitable due to requirements for real-time data or source constraints, you may consider these alternatives:
- Apply filters to limit the number of rows displayed in each visual.
- Aggregate your data to a higher level, such as by month or category.
- Leverage composite models to combine Import and DirectQuery where appropriate.
Hope this helps. Please reach out for further assistance.
Thank you.
Hi psathanapal ,
I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.
Thank you.
Hi psathanapal ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.
Hi psathanapal ,
We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.Thank you.
