Hi I've been looking at this for a while now and google isn't giving me any easy answers.
I have a datasource con nection set up to an oracle database, in which I have a made some views to generate datasets which I use to chart in power BI.
I've been testing this over the last week or so to autorefresh and they have been working fine, I refreshed them today (I've made no changes to the BI report or script that generates the view) and data that previously loaded has now disappeared.
Selecting from the view in ORacle directly returns the exact data I want, so it's not the script, I have other data sources that pull from oracle database views that are still working as well. But this particular one no longer refreshes even though it's just a different view under the same data connection, database, user etc.
Can't work out what's going wrong, as there's nothing obviously broken - no error messages or failures, it just loads an empty table with the correct column headers but no data.