Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

My Data Dilemma with Power Query & Power BI

Hello Everyone,

I have three sets of tables to complete a material order.

The first table includes the project number (Proj #), description, schedule start date, and expected delivery date. Each project number has more than three design codes

The second table consisting of the design code includes the quantity of design complete for each design code. For each design work complete, there are multiple material id’s associated with each design code.

The third table consisting of the material code includes the metric units per material order expressed in feet, count of units, assembly etc.

As a result, my query is returning a many-to-many or one-to-many relationship error. I have watched and researched several videos online and read different articles but none of them have proofed to be helpful now.

Therefore, I was hoping that someone on this forum might have a better understanding to help me understand and resolve this problem in (1) Power Query, (2) PowerPivot, and (3) Power BI.

If needed, I can e-mail you sample data or post a few example later to give you an example scenarion

Thank you.



Re: My Data Dilemma with Power Query & Power BI



I ran a session on Many to Many in DAX a few weeks ago:

I am covering the following topics : DAX, Power Query, Data Modelling.


Tell us if it helped you !

Helpful resources

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.



Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors