Good morning,
We've built a very nice report using data coming from our Oracle databases. The report works very well on PowerBI Desktop and take around 50min to be refresh.
We publish it on PowerBI online in order to have an automate refresh but the refresh drop in error telling us somebody cancel the job
Underlying error code: | -2147467259 Table: DGR_STAT_TABLES. |
Underlying error message: | Oracle: ORA-01013: user requested cancel of current operation |
We've check and our oracle database which see the technical account accessing the data
On the gateway, no errors highlight (except the previous error)
The firewall port are well open (we've test it).
What we've notice in our PowerBI report is if we remove the oracle view DGR_STAT_TABLES, the refresh works smoothly. So I try to recreate step-by-step part of the operations done during the report's creation.
The "get date" to the view works well but the refresh start to fail when we do a replace value.
let
Source = Oracle.Database("NBIDGIP1", [HierarchicalNavigation=true]),
REPO_MM = Source{[Schema="REPO_MM"]}[Data],
DGR_STAT_TABLES1 = REPO_MM{[Name="DGR_STAT_TABLES"]}[Data],
#"Replaced Value" = Table.ReplaceValue(DGR_STAT_TABLES1,"XXX_SQL_SERVER","SQL Server",Replacer.ReplaceText,{"DBMS"}),
#"Changed Type" = Table.TransformColumnTypes(#"Replaced Value",{{"NBR_TABLES", Int64.Type}}),
#"Replaced Value1" = Table.ReplaceValue(#"Changed Type","XXX","SQL Server",Replacer.ReplaceText,{"DBMS"})
in
#"Replaced Value1"
In the meanwhile, we've see also sometimes the refresh work (???) We are a little lost
Any help ?
