web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / You do not have any en...
Small and medium business | Business Central, N...
Answered

You do not have any environments. Please create one and try again. - Accessing Customer's Business Central Tenant from Power BI

(0) ShareShare
ReportReport
Posted on by Rebe.Gwaindepy 178

Hi guys,

I have delegated admin rights to a client's business central tenant and i am trying to connect to the Business central from power BI desktop. However i get the error "You do not have any environments. Please create one and try again." and it looks like Power BI cannot access the customer's tenants.

My question is:

As a partner, how do i create power bi reports for the client on their tenant?

Kind regards,

Kuda

I have the same question (0)
  • _prashant_ Profile Picture
    _prashant_ 5 on at
    RE: You do not have any environments. Please create one and try again. - Accessing Customer's Business Central Tenant from Power BI

    Hi.

    In Power BI Desktop, the connector (Business Central online via Get Data) reports 'We couldn't authenticate with the credentials provided'.  It shows the environment but does not load any tables, etc. and is stuck loading.  The B2B (Guest) user is confirmed to be able to access the Business Central environment through the web client and the user is successfully able to access reports in the Power BI tenant.  The user is logged in to the organization in the application.  A fresh install on another device was also factored out (produced the same results).

    Any ideas?

    Perhaps it needs an explicit /tenant/environment/company, etc., in the URL it fetches?  Can this be modified on this particular connector?

    Thank you.

    Edit: Using ODataV4 to connect (rather then the pre-built BC online connector), appears to be working.

  • Verified answer
    Rebe.Gwaindepy Profile Picture
    Rebe.Gwaindepy 178 on at
    RE: You do not have any environments. Please create one and try again. - Accessing Customer's Business Central Tenant from Power BI

    This is how  i managed to get it to work:

    1) added as a guest user on client tenant

    2) guest user assigned BC license

    3) allow external users to access Power BI content on Power BI admin portal - tenant settings

    4) On power BI desktop sign in to an organisation (client tenant)

    5) open the BC connector

    6) signed into BC in to an organisation (client tenant)

    7) All good

  • Suggested answer
    Rebe.Gwaindepy Profile Picture
    Rebe.Gwaindepy 178 on at
    RE: You do not have any environments. Please create one and try again. - Accessing Customer's Business Central Tenant from Power BI

    Hi guys,

    After hours of trying, i  managed to get it done from a different computer. the problem was actually coming from the BC connector which had cached my Tenant details and was using them on the other tenant. 

    I tried clearing cache, data and even uninstalling and it not working. So for now i am using a different PC to connect to the client environment.

    Kind regards,

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 91,218 Super User 2025 Season 2 on at
    RE: You do not have any environments. Please create one and try again. - Accessing Customer's Business Central Tenant from Power BI

    Hi, hope the following helps as well.

    https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-azure-ad-b2b#considerations-and-limitations

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,035 Moderator on at
    RE: You do not have any environments. Please create one and try again. - Accessing Customer's Business Central Tenant from Power BI

    Unfortunately you can not be a guest user in your customers AD when you try to connect to their Power BI environment. You will have to make them create you as a regular user.

  • Rebe.Gwaindepy Profile Picture
    Rebe.Gwaindepy 178 on at
    RE: You do not have any environments. Please create one and try again. - Accessing Customer's Business Central Tenant from Power BI
    [quote user="Rebe.Gwaindepy"]
    Inge M. Bruvik said:

    Unless you have a user belonging in the customers Azure AD the correct way would be the create a Power BI app that the customer can deploy in their Power BI environment. The same way that it is done with the standard Power BI apps for BC.

    Maybe you find some hints here:

    docs.microsoft.com/.../deployment-pipelines-process

    The easy work around is to have your customer create a user for you in their AD. But then they will have to pay for your licenses.

    Hi Inge M. Bruvik and ZHU YUN ,

    Thanks for taking sometime to assist. here is a little background to the problem:

    The client created me as a guest on the Azure Tenant and my guest email looks like kudakwashe.gwaindepi_mydomain@CustomerDomain.OnMicrosoft.com, assigned me a Power BI free license (though i already have a Pro license), gave me access to business central (i can log in fine), i can even sign in on power BI desktop using the sign into an organisation option, though it is not showing my email address like it normally does when i sign into my tenant:

    pastedimage1663620006486v1.png

    When i get data, and select Dynamics 365 Business central is get the below error:

    pastedimage1663620169395v2.png

    I am sure i am connected to the client tenant because if i change my Last name on their side it changes on my power bi. I am just confused as to why Power BI desktop would say i dont have business central environments.

    Kind regards,

    Kuda

    [/quote]

    in addition i have been following  this whitepaper Distribute Power BI content to external guest users using Azure Active Directory B2B - Power BI | Microsoft Learn as a guide

  • Rebe.Gwaindepy Profile Picture
    Rebe.Gwaindepy 178 on at
    RE: You do not have any environments. Please create one and try again. - Accessing Customer's Business Central Tenant from Power BI
    [quote user="Inge M. Bruvik"]

    Unless you have a user belonging in the customers Azure AD the correct way would be the create a Power BI app that the customer can deploy in their Power BI environment. The same way that it is done with the standard Power BI apps for BC.

    Maybe you find some hints here:

    docs.microsoft.com/.../deployment-pipelines-process

    The easy work around is to have your customer create a user for you in their AD. But then they will have to pay for your licenses.

    [/quote]

    Hi NorthW and yzhums ,

    Thanks for taking sometime to assist. here is a little background to the problem:

    The client created me as a guest on the Azure Tenant and my guest email looks like kudakwashe.gwaindepi_mydomain@CustomerDomain.OnMicrosoft.com, assigned me a Power BI free license (though i already have a Pro license), gave me access to business central (i can log in fine), i can even sign in on power BI desktop using the sign into an organisation option, though it is not showing my email address like it normally does when i sign into my tenant:

    pastedimage1663620006486v1.png

    When i get data, and select Dynamics 365 Business central is get the below error:

    pastedimage1663620169395v2.png

    I am sure i am connected to the client tenant because if i change my Last name on their side it changes on my power bi. I am just confused as to why Power BI desktop would say i dont have business central environments.

    Kind regards,

    Kuda

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 91,218 Super User 2025 Season 2 on at
    RE: You do not have any environments. Please create one and try again. - Accessing Customer's Business Central Tenant from Power BI

    Hi,  I'm not sure if this has anything to do with the info below, hope it gives you some hints.

    https://docs.microsoft.com/en-us/partner-center/gdap-supported-workloads#power-bi

    pastedimage1663288982028v1.png

    Thanks.
    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,035 Moderator on at
    RE: You do not have any environments. Please create one and try again. - Accessing Customer's Business Central Tenant from Power BI

    Unless you have a user belonging in the customers Azure AD the correct way would be the create a Power BI app that the customer can deploy in their Power BI environment. The same way that it is done with the standard Power BI apps for BC.

    Maybe you find some hints here:

    docs.microsoft.com/.../deployment-pipelines-process

    The easy work around is to have your customer create a user for you in their AD. But then they will have to pay for your licenses.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sumit Singh Profile Picture

Sumit Singh 3,227

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,866

#3
Sohail Ahmed Profile Picture

Sohail Ahmed 2,682 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans