Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I would ask you about Power BI connection with Dynamics 365 Business Central cloud. Is it possible that something change in relationship in last updates??
I was creating report using Business Central on premise and all relationship worked perfect, now when I change database to cloud (migrate data from on premise to cloud BC) I want to use exacly the same tables as before but relationships don't work properly. I need to have relationshisp one-to-many but I can have only many-to-many. Strage situation, please help.
is the data exactly the same? sometimes the relationships flag this issue if there is a null in a key column at one end of the relationship.
(Sorry Amit - overlapping messages :))
Thank you so much for your replay.
Yes, data are exacly the same. I was preparing report based on this data in January and even if I had null value in one key column I could create relationship one to many. Now I can't. Is there any option solve this problem? Now we need to implement this report on client side and we can't.
@ola1996 , if you get a null value on the one side. It will become many to many
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |