Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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!