Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hola comunidad
Os presento el caso que se me ha presentado por si me podéis ayudar
Tengo dos áreas de trabajo eb Fabric. En cada una de estas áreas de trabajo tengo un flujo de datos dataflow GEN 2 que se conectan a un origen de datos Business Central SaaS de Microsoft mediante el conector de Business Central. Cada flujo de datos de conecta con una cuenta de usuario distinta. El problema que tengo es que no puedo actualizar automáticamente los flujos de datos. Esto es porque solo puedo tener una conexión en la nube a Business Central en mie entorno de Fabric, no encuentro la manera de tener conexiones distintas en cada área de trabajo. Por lo que si pongo en la conexión unas credenciales de acceso a Business Central, el otro flujo de datos falla. ¿Tienen una solución a este problema, de forma que pueda tener conexión a origen de datos Business Central distintas para cada área de trabajo o que cada una pueda tener credenciales de acceso distintas?
Solved! Go to Solution.
Hi everyone
The solution that worked:
1. Use web connector instead of Business Central connector
2. Register the app in Azure Microsoft Entra ID
3. Grant Business Central permissions in the app
4. Use a service principal in the web connector passing the tenantID, clientID and the secret key of the app
The final solution I have applied is to use OData connector instead of Business Central connector.
Thanks
The final solution I have applied is to use OData connector instead of Business Central connector.
Hi everyone
The solution that worked:
1. Use web connector instead of Business Central connector
2. Register the app in Azure Microsoft Entra ID
3. Grant Business Central permissions in the app
4. Use a service principal in the web connector passing the tenantID, clientID and the secret key of the app
Hi @JavierGonz ,
Currently only one cloud connection to Business Central is allowed per environment in Fabric Data Factory. So I think you can take the following steps to try to resolve your current issue:
1. Instead of using the same dataflow for both work areas, create separate dataflows for each workspace. This way, each dataflow can have its own connection settings and credentials.
2. If possible, use service principal authentication instead of user credentials. This allows you to create separate service principals for each workspace, each with its own set of credentials. You can look at this document: Data source management - Microsoft Fabric | Microsoft Learn
3. I think you can also use Power Automate to schedule and manage the refresh of your dataflows. You can create separate flows for each workspace, each using different credentials.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanh you for the reply.
The data flows are different and are separated each in a work area.
Creating a service principal is not a solution, since the connector only supports organizational accounts.
Creating a Power Automate data flow to schedule the update does not solve the problem of different access credentials for each workflow. There is no way to use two different connectors, each with its own access credentials.
The problem is that I am trying to access different Business Central tenants, so I need to be able to access with two different credentials. I can access the data, but when performing the scheduled update of the data flow only the last one in which the credentials were passed is updated, the other one also uses the same credentials and fails.
Check out the October 2024 Fabric update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
4 | |
3 | |
3 | |
2 | |
1 |
User | Count |
---|---|
6 | |
5 | |
5 | |
4 | |
2 |