Hello,
We have Business Central Cloud.
A part of our operations is made by another company, with their AAD domain, but they do those operations on our Business Central. The users are setup in our domain to be able to access what they need to acces. So far so good.
They are trying to setup a PowerBI report to track performance and they managed to use the BC connector to get the data from our domain using the "advanced" sign-in method where you can specify the domain you want to connect to.
But when they publish the report and attempt to refresh it, they get an error saying that the BC company is impossible to find, as if the report is trying to look into their BC environnement instead of ours.
I cannot find documentation on how to properly set-up everything so the published report works as expected. Is it even possible for a Power BI hosted on one domain to connect to a BC environement in another domain ? And if not, what would be the recommended way of achieveing this ?
Thank you