Integrating Nav and Power BI (2016)

[ayodhya1998]

Hi all,

I'm trying to connect Navision and Power BI, However when I paste the ODATA URL I get this error. Could someone help me with this. The covered part is the company name,

Thanks in Advance, 

[Anonymous · Accepted solution]

Hi @ayodhya1998 ,

Please try below steps to troubleshoot this issue:

1. Check the OData URL: Ensure that the OData URL you are using is correct. It should typically follow this format: `http://[YourServer]:[ODataPort]/[Instance]/OData/Company('[YourCompanyName]')`

2. Verify Permissions: Make sure that the account you are using to access the OData feed has the necessary permissions in NAV to access the data.

3. Test the OData Feed: Try accessing the OData URL directly in a web browser or using a tool like Postman to ensure that the feed is working correctly.

4. Firewall and Network: Check if there are any firewall settings or network issues that might be blocking the connection between Power BI and your NAV server.

5. Update Power BI Desktop: Ensure that you are using the latest version of Power BI Desktop, as updates often include fixes for connectivity issues.

6. Use the Web Connector: In Power BI Desktop, you can use the Web connector to connect to the OData feed. Here's how:
- Open Power BI Desktop.
- Go to Home > Get Data > Web.
- Enter the OData URL and proceed with the connection.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ayodhya1998]

thank you. if I have read only permissions for Navision data, can I use OData feed to extract the data?