Scheduled Refresh is not working with ODBC and excel data sources.

[Anonymous]

Hi All,

I am having a Dashboard published on Power BI Report Server.

Data sources for this report is Excel and ODBC.

Now I want to apply Schedule Refresh for this report; 

But when I am trying to do this, it is always giving me an error : 

 

An error has occurred.

Something went wrong. Please try again later.

Also when I am trying to check whether connection is successfully establishing or not..I came to know that for odbc data source connection is not establishing and same for the Excel data source.

I am totally not getting why is this happening.

Please help.

TIA.

Regards,

Shraddha.

[sampanda · Accepted solution]

I worked with your team member and the issue is resolved. The isuse was with the web portal and web service URL.. both of them were using the same URL http://servername/reports. it has to be different URL. Once that is done, the Schedule refresh connecting to MongoDb through ODBC is resovled.

[Anonymous]

Hi @sampanda,

Yes, understood the cause.

Thank you so much for your support and help!! 🙂

Regards,

Shraddha.