Error when trying to extract data from Oracle PBCS

Used for anything related to the new Power BI Desktop and Service tools
gsenol
Posts: 1
Joined: Mon Dec 16, 2019 5:26 pm

Error when trying to extract data from Oracle PBCS

Postby gsenol » Mon Dec 16, 2019 5:42 pm

Hi all,

I'm trying to get data from PBCS, which is a cloud application provided by Oracle for financial budget and forecasting processes.

I'm able to get the data in Postman successfully. But the same script gives me an error on PowerBI.

I'd appreciate if you could help me with this one.

The error:
DataSource.Error: Web.Contents failed to get contents from '<MyURL>' (500): Internal Server Error

Steps:
1. new data source, blank query
2. Advanced editor
3. My query:

[i]let
authkey = "Basic <...>",
body = "
{
""exportPlanningData"": false,
""gridDefinition"": {
""suppressMissingBlocks"": true,
""pov"": {
""dimensions"": [

""Yil"",

""Genel1"",
""Genel2"",
""Genel3"",
""Genel4"",
""Mal_Grubu"",
""MasrafYeri"",
""Muhatap_Sirket"",
""Para_Birimi"",
""Senaryo"",
""Sirket_Kodu"",
""Ulke"",
""VeriKaynagi"",
""Versiyon""
],
""members"": [

[
""FY19""
],

[
""BayiSatis""
],
[
""TİP1""
],
[
""OB""
],
[
""Genel4Yok""
],
[
""MG140""
],
[
""MM_Yok""
],
[
""NA_MUH""
],
[
""TRY""
],
[
""Butce""
],
[
""71""
],
[
""TÜRKİYE""
],
[
""S1""
],
[
""Butce2020_0915""
]

]
},
""columns"": [
{
""dimensions"": [
""Donem""
],
""members"": [
[
""IDescendants(YearTotal)""
]
]
}
],
""rows"": [
{
""dimensions"": [
""Hesap""
],
""members"": [
[
""SD1020""
]
]
}
]
}
}",

Source= Json.Document(Web.Contents("Https://planning-test-a589549.pbcs.em2.oraclecloud.com",
[
Headers=[#"Authorization"="Basic YTU4OTU0OS5HdGVjaDpUZW1zYTIwMDA=",
#"Content-Type"="application\Json"
],
RelativePath="/HyperionPlanning/rest/v3/applications/TEMSA/plantypes/Plan1/exportdataslice",
Content=Text.ToBinary(body),Timeout=#duration(0,2,0,0)
]))
in
Source[/i]
4. From data source settings I choosed anonymous for the URL.

Thanks

Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 1 guest