I am trying to do a relationship (one to many) for a date field.
One table (date) contains the days of the year since 2017 (1194 rows) , and the other table (called query1) contains 830,000 rows with a column date.
I got this message:
How can i fix this?
Solved! Go to Solution.
I'm with @parry2k that seems odd. How much memory do you have? You could try to turn off the automatic date hierarchy in File | Options and settings | Options. I have seen that blow up some data models because every date is unique.
The file size is 62 MB, I have the PBI pro version. In the end worked, by just doing the bridge from date to query (the heaviest table), instead of table to formula.
@o59393 wow never seen that. can you put these two tables in a seperate pbix , don't add any measure and try to create the relationship.
Do you have many dax measures in this model?
Check out the News & Announcements to learn more.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
Mark your calendars and join us for our next Power BI Dev Camp!
Check out our new Discover Your Career Path blog post series and get all the details.