business central sandbox

[luchino]

hello, I'm trying to connect to Business Central Sandbox from Power BI desktop, but I'm not able. it looks that PowerBI only connect to Production environment. any idea?

thank you

 Luca

[mwegener]

Hi @luchino ,

in the meanwhile the sandbox is displayed in the navigator.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[mwegener]

Hi,

as workaround you could connect via OData-Feed and basic authentication (username and web service access key as password)

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-develop-con...

best regards

Marcus

[v-yuta-msft]

Hi luchino,

This is more related to dynamic365. You should create a sandbox environment first in dynamic365, please refer to: https://docs.microsoft.com/en-us/dynamics365/business-central/across-how-create-sandbox-environment.

Regards,

Jimmy Tao

[luchino]

thank you for you reply. I already have a Sandbox anvironment. simply when I connect to PowerBI, I chose BusinessCentral as service, I set my credential, and the PowerBI directly goes to the production environment. no way to change it and log to the sandbox already in place.

thank you

Luca

[v-yuta-msft]

Hi luchino,

I would recommend you to post your issue to dynamic365 forumn to achieve further support.

Regards,

Jimmy Tao