Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Report does not refresh on schedule

I've worked with several experienced Power BI developers here at work to find a solution for this issue. So far, we haven't been able to resolve. I've searched and tried all the suggestions in this c...
Need Help
nickyvv's avatar
nickyvv
Most Valuable Professional
6 years ago

Hi Anonymous, 

 

you say you have a SQL Server as a datasource, but have a web, file and SP connector? That seems odd to me.

Could you elaborate a bit more? Or show the connections in PBI Desktop?
Do you have a gateway set up?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    The report has two data sources, SQL server and Excel file. I used the web, file and SP connector on the Excel datasource. We have a corporate gateway we use on SQL server datasources. 

    The connections in desktop are straighforward. I connected to SQL server and Excel as recommended by Microsoft and other developers. It refreshes fine in desktop... it's not refreshing the actual data in the Power BI online. The dataset history shows it refreshed correctly with no errors, except the actual data hasn't changed. If i manually refresh, same result. it shows it refreshed but the data didn't update.