Answered

Dataverse Many to Many field in Power Bi Dataflow

(0) Share

Report

Posted on by Dalebid1

Hi I'm trying to import some Dataverse data into Power BI using a dataflow, the two tables I'm using have a Many to Many relationship, might be something obvious I'm missing! But how do I access the hidden intersect table that joins the two?

Thanks

Dale

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Dalebid1 44 on at

Like (0)

Report

Found it, there was a system generated table in the list of tables within Power Query which has the mappings,should have looked harder!

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Dalebid1 :

Thank you for sharing the solution.

Glad to hear that you have solved the problem yourself.

Best Regards,

Bof

Was this reply helpful? Yes No