Forum Discussion
Oracle Server Down
Hi Steve_Lang ,
I continued to test and found that the TestForError step should deepen into the table, otherwise it returns False even though the service is available.
TestForError = try Source[<One table name in your database>],Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
HI,
It seems to error when calling Oracle.Database(...)
let
Source = Oracle.Database("..server.."),
TestForError = try Source,
Output =
if TestForError[HasError] then
Table.FromRecords({}, {..Field names..})
else
let
Source2 = Oracle.Database("..server..", [Query="..SQL..", HierarchicalNavigation=true]),
#"Changed Type" = Table.Transf... etc
#"Final Transformation" = Table.AddCol..
in
#"Final Transformation"
in
Output
I have created a pararmeter to switch on or off and if it does not try the Oracle Server i have no Error, when the Parameter ServerUp is set to False
if ServerUp = true then try Oracle.Dat....
Hi Steve_Lang ,
I continued to test and found that the TestForError step should deepen into the table, otherwise it returns False even though the service is available.
TestForError = try Source[<One table name in your database>],
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum