Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a PBI-Report that uses an oracle database as main source. The report has been refreshing fine for the past weeks using the enterprise gateway. However, since this morning I get an error (ORA-01722: Invalid Number). So, in order to locate the field in the data source I refreshed the dataset in PBI-Desktop, but there the refresh works fine...so I have no idea how to fix this since I cannot look into the the details of what goes wrong during the process.
Any ideas?
Thanks a lot in advance,
Nico
Here´s the error message:
Fehler bei der letzten Aktualisierung: Thu Aug 17 2017 06:23:33 GMT+0200
Mit der Mashupdatenquelle kann keine Verbindung hergestellt werden. Weitere Informationen finden Sie in den Fehlerdetails.Details ausblenden
Zugrunde liegender Fehlercode: | -2147467259 |
Zugrunde liegende Fehlermeldung: | Oracle: ORA-01722: invalid number |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.ValueError.DataSourceKind: | Oracle |
Microsoft.Data.Mashup.ValueError.DataSourcePath: | proee.soptim.net |
Microsoft.Data.Mashup.ValueError.ErrorCode: | -2147467259 |
Microsoft.Data.Mashup.ValueError.Message: | ORA-01722: invalid number |
Microsoft.Data.Mashup.ValueError.Reason: | DataSource.Error |
Cluster-URI: | WABI-EUROPE-NORTH-B-redirect.analysis.windows.net |
Aktivitäts-ID: | 1613cf2c-954e-4953-9fcc-3934dd2bbc6c |
Anforderungs-ID: | c5b7d1bc-ab16-464e-a5a4-a525181a204e |
Zeit: | 2017-08-17 04:23:33Z |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.