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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Ruhankarim
Regular Visitor

This visual has exceeded the available resources. Try filtering to decrease the amount of data.

This Issue is already mentioned here in Power BI Community however I didn't get the required solution of this issue from previous suggestion.

I am trying to visulize running total over time for job that got finished in past 30 Days using this

 

DAX:

Calculate([Finished],
Flilter(All( DateTable[Date]),
         ISONORAFTER(DateTable[Date], MAX(DateTable[Date]),Desc)

 

Created This Model:

Ruhankarim_0-1695988311136.png

Getting This Error:

For Simple Line Chart Using Running Total and Date in X and Y axis.

 

Ruhankarim_1-1695988389981.png

Then I removed the relationship between tables 

Ruhankarim_2-1695988444713.png

 

and again getting the same error.

Ruhankarim_3-1695988487592.png

 I am using Oracle DB as a Datasource through Import mode and it is querying around 32lac rows and 9 columns. Also Power BI Desktop I am using is in Citrix Workspace.

 

Would request you to please suggest any solution for this error, I will be  grateful to you for your help .

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Please read about star schema data models. You are supposed to have dimensions (like your date dimension) that have unique key columns (like the date column) so that your relationships to the fact tables can be 1:* rather than *:*.

 

Resources exceeeded = cartesian products getting too big. Good data models prevent that from happening.

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

Please read about star schema data models. You are supposed to have dimensions (like your date dimension) that have unique key columns (like the date column) so that your relationships to the fact tables can be 1:* rather than *:*.

 

Resources exceeeded = cartesian products getting too big. Good data models prevent that from happening.

Thank you Very much for this suggestion, I changed the relationship from one to many and now it is working fine for me.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.