Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 310 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Setup Power BI in multi-tenant environment
knm
Member Posts: 170
I was looking for this topic for few days now but wasn't able to find any appropriate information on this, so I'm posting this question in this thread.
I'm currently testiong NAV2017, and my goal right now is to build a multi-tenant environment where each tenant can connect to PowerBI.com, and show the reports on the RoleCenter (new feature in NAV2017).
I'm failing when I'm trying to add the NAV Content Pack from the PowerBI.com, and I don't know what to put in the parameters.
Below is what I'm entering, and I'm getting an error "Failed to update data source credential"
URL = https://[server]/DynamicsNAV100/OData/Company('[Company Name]')/?tenant=[tenant name]
Authentication Method = Basic
User name = [user name defined in NAV]
Password = [password defined in NAV]
Any idea where I'm doing this wrong?
Note:
I'm currently testiong NAV2017, and my goal right now is to build a multi-tenant environment where each tenant can connect to PowerBI.com, and show the reports on the RoleCenter (new feature in NAV2017).
I'm failing when I'm trying to add the NAV Content Pack from the PowerBI.com, and I don't know what to put in the parameters.
Below is what I'm entering, and I'm getting an error "Failed to update data source credential"
URL = https://[server]/DynamicsNAV100/OData/Company('[Company Name]')/?tenant=[tenant name]
Authentication Method = Basic
User name = [user name defined in NAV]
Password = [password defined in NAV]
Any idea where I'm doing this wrong?
Note:
- My environment is setup with NAV2017 CU1 NA
- I can confirm that when I enter the above OData url, I can get to list of published web services
0
Answers
I've been trying to accomplish the same, but without any luck.
Can you please check if you have followed all the steps in the below link:
https://powerbi.microsoft.com/en-us/documentation/powerbi-content-pack-microsoft-dynamics-nav/
Trying this steps should help to connect PowerBI without any issues.
Yes, I did.
The problem is with the MultiTenant setup in NAV.
It's described very well here, I think:
https://community.powerbi.com/t5/Desktop/Unable-to-connect-to-NAV-using-ODAta/m-p/148473#M65053
I've not yet managed to test the recommendations from that thread fully, as I'm waiting for our hosting provider to set up CNAME records for the alternate tenant ids, but I'm working on it.
Thanks for confirming that it works! With this latest suggested solution of using Alternative ID, I re-attempted to use the "Dynamics NAV Content Pack" available on PowerBI, but I am still unable to get this to work.
Below are some of the key information when I was testing, can you help to point out if I'm missing anything?
1) Setup the tenant with Alternative ID
2) Confirmed that I can access the OData using web browser, directly through Alternative ID
3) Confirmed that I can access the Web Client through Alternative ID
4) When setting up the PowerBI, I made sure that I use the same address as that I used on #2
I'm getting the following error message.
Failed to update data source credentials
knm