Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
Microsoft Dynamics NAV 2016 includes an entirely new integration with Microsoft Power BI.
In Microsoft Dynamics NAV 2016, using the new Power BI Content Pack, Microsoft Dynamics NAV end users can connect a correctly configured Microsoft Dynamics NAV instance to PowerBI.com and immediately be able to see full business performance insights in a dashboard.
The PowerBI.com content package for Microsoft Dynamics NAV 2016 empowers you to share and present data across an organization. Data can be defined centrally but be consumed, modified and presented to the local needs of users, while everybody still sees data from the same overall picture.
Users can create their own KPIs and charts, select data from queries, set filters, select visualizations and more to create their own dashboards
It takes less than five minutes to get going! Depends upon net speed and volume of data.
Make sure OData Service is enabled and Port for same is defined in your Server Instance of Navision.
Check that the Page 197 Service powerbifinance is published in Web Services window. Copy the OData URL we will be requiring it while connecting to content pack for Dynamics 2016 in BI.
Go to PowerBI.com and sign in or go through the easy account setup process.
Sign in to Power BI using your credentials.
You first get to a page to select your data source.
The data sources are OData feeds, such as OData web services from any Microsoft Dynamics NAV solution.
In this case select Services to get to content packages. Refer below how to connect.
Select the content package for Microsoft Dynamics NAV.
You will be prompted to add the URL to your Dynamics NAV instance.
An easy way to obtain this URL is in Dynamics NAV to go to Web Services, find the powerbifinance web service and copy the Odata URL, but leaving out the “/powerbifinance” from the URL string.
When you paste in the copied URL, you must remove the last part of the web service-specific URL: “/powerbifiance” – you only need the company-specific part of it
After entering the URL You will be prompted to select an authentication method.
Select the appropriate method and provide the relevant user credentials.
Here you provide the OData URL we saved above. Enter your Authentication Mode and provide your User ID and password to get connected to the data.
When you select Log on, it will take a few minutes for the content package to connect to your Dynamics NAV instance, get the data and create the dashboard and reports.
“Parameter validation failed, please make sure all parameters are valid”
If you see this error after typing your Microsoft Dynamics NAV URL. Make sure the following requirements are satisfied:
– The URL follows exactly this pattern https//instance.navserver.com:7048/DynamicsNAV90_Instance1/OData/Company(‘CRONUS%20International%20Ltd.’) replacing ” instance.navserver.com” with your NAV Server name, “DynamicsNAV90_Instance1” with your NAV Server Instance name and “Company(‘CRONUS%20International%20Ltd.’)” with your NAV Company name.
– Make sure all the letters are lower case.
– Make sure the URL is in ‘https’.
– Make sure there are no trailing forward slash at the end of the URL.
If you get a “login failed” error after using your Microsoft Dynamics NAV credentials to login, then the account you are using doesn’t have permissions to retrieve the Microsoft Dynamics NAV data from your account. Verify it is an admin account and try again.
Let’s see what data exactly this page provides:
Depending on whether you use your own database or the demo database, the charts in the dashboard might have different content or none at all.
We will see rest details in my upcoming post.
Business Applications communities