Excel/PowerBI OData import gives internal server error 500

Lukas Jakutis

I have Navision server up and running and I want to extract some data from it using Excel/Power BI and OData feed.

If (in Excel) I import Get External Data ->Other Sources -> OData Data Feed, I use Navision generated OData link and it succesfully imports data using Windows Authentification, but if I use New Query -> Other Sources -> OData Feed I input the same link and the same user and it gives:

Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:

OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (An error has occurred.)

OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (An error has occurred.)"

Same issue when connecting with through PowerBI I've tried using local NAV user and Basic authentication and the issue is still the same.

OData and SOAP services are enabled.

EDIT: When connecting using local NAV account with Basic authentication it says "We couldn't authenticate with the provided credentials" even though the users are created the same

Lukas Jakutis

Solved by adding Alternative Tenant ID's to NAV instance tenants and adding those Alt ID's to hosts

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-12-1

Comments

0 comments

TOP Ranking

Article

Excel/PowerBI OData import gives internal server error 500

Excel/PowerBI OData import gives internal server error 500

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

pump.io port in URL

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

How to import an asset in swift using Bundle.main.path() in a react-native native module

How to use HttpClient with ANY ssl cert, no matter how "bad" it is

Modbus Python Schneider PM5300

What is the exact difference between “ use_all_dns_ips” and "resolve_canonical_bootstrap_servers_only” in client.dns.lookup options?

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

BigQuery - concatenate ignoring NULL

split column by delimiter and deleting expanded column

Unable to use switch toggle for dark mode in material-ui

Soundcloud API Authentication | NodeWebkit, redirect uri and local file system

Apache rewrite or susbstitute rule for bugzilla HTTP 301 redirect

Is there an option for a Simulink Scope to display the layout in single column?

UWP access denied

Center buttons and brand in Bootstrap

express js can't redirect user

Make a B+ Tree concurrent thread safe

Printing Int array and String array in one

Google Chrome Translate Page Does Not Work

Elasticsearch - How to match number range in string