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.
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 ?
Do you think this can come from the gateway ? or from the oracle database ? From PowerBI desktop ? The three ? 🙂
hi, @Wolfiz
Please try to update the gateway to lastest version.
and maybe your dataset is too big, it leads the gateway might be overloaded.
Please try to copy the report and filter the dataset to a small dataset and refresh it again.
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.