I have 3 views that I have set up in oracle that I used as direct data sources in power BI. 2 of these currently do not work and I can find no reson for this, they were working fine when I first made them, but have since stopped.
I can select from the view in oracle itself and see the data, but if I refresh in power BI I get a blank tablejust with the column headers.
I've treid re-building the links to data sources and double checked the queries that power bi has to get the data and all seem fine, it just will not return the data that I know is there. I get no errors, or timeouts, it appears to carry out the refresh each time, but remains empty.
I could really use some help on identifying why the data sourced from a view is suddenly not showing through, I've made no changes to them since before they last attempted to refresh, and 1 of them still works as I expected, it's just the other ones have suddenly stopped with no obvious cause.
Hi @Adamadamadam ,
What version of power bi desktop you test? Is there any difference between these data views? I think this issue should more related to database side.
Please provide more detail informations to help us clarify your scenario.