The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have a single file that I'm adding to a remote DQ model via live connection. The only common join I have is the most granular being the ID. I don't have other common dimensions in my file. When I calculate anything...it causes the 1Mil row error because, I assume, PBI is pushing the calculation back to the cloud and calculating over every ID.
Question:
Is there a way to do a lookup function to add the dimensions needed to my file...so I can speed up the calculations and not rely on joining at the ID level? If not...what are my other options. It seems I need to create a temp table possibly...somehow joining at a higher level than ID. Much appreciate any help!
User | Count |
---|---|
56 | |
54 | |
53 | |
47 | |
30 |
User | Count |
---|---|
173 | |
89 | |
70 | |
46 | |
45 |