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

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
superpower
Frequent Visitor

Many-Many

Hi!

In my report, there are multiple set of tables with many to many relationships. I have created bridge tables and able to solve the report. But the problem is, the data is very huge for these tables almost more than 300+ million rows. So, when I created the bridge table, the memory is doubled up and the file size has blown up to 6 GB. I tried to convert the tables to direct query but some of the transformations that I did for creating bridge tables are not supported in direct query. So, are there any options to create a bridge table virtually that doesn't oaccupy any additional memory.

Thanks

 

1 REPLY 1
amitchandak
Super User
Super User

@superpower , if you have SQL source , create a new connection and in that write a SQL to select distinct values.

 

Or try in DAX

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.