Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
Getting This Error:
For Simple Line Chart Using Running Total and Date in X and Y axis.
Then I removed the relationship between tables
and again getting the same error.
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 .
Solved! Go to Solution.
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.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |