I am new to all things power bi. I created a report with a datasource connected to a local db and excel file. I have published the report to power bi. I installed the power bi gate way. I have linked my published report datasource to the gateway and made connections to the local sql database and excel file. All connections authenticated as expected. I set the refresh schedule to occur every 30 minutes.
the data in my report remains stale. the gateway/datasource says it is refhreshing, but the data remains stale. I have tried changing the datasource in the report from direct query to import, but no change.
What am i missing? Is there another setting hidden in this wonderfully easy to use microsoft product that needs to be activated to allow my reports show current data?