160
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
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.
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
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,
Hi, hope the following helps as well.
Thanks.
ZHU
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.
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:
When i get data, and select Dynamics 365 Business central is get the below error:
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
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]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:
When i get data, and select Dynamics 365 Business central is get the below error:
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
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
Thanks.
ZHU
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.
#1
André Arnaud de Cal...
283,860
Test role Public
#2
Ludwig Reinhard Microsoft Employee
#3
Martin Dráb
225,155
Moderator
Share
Report
All responses (
Answers (
