Forum Discussion
Report Server October Release refresh fails
Hi, So I am having trouble getting data to refresh with a SQL Server Connection in the new version of Power BI Report Server. I created a brand new report in the October Report Server Desktop v...
So I found the problem.
There were 2 data sources in the model pointing to the same database and for some reason I could not enter credentials for the second data source as the second one disn't show up.
The reason there were 2 was that the database name was all lower case in one source and camel case in the other.
I used the advanced editor in desktop to rename them to be unique and then there was one source and data refreshes fine.
Thanks for the reply!!
I've done that and the connection was successful.
I bounced the server in hope but no luck.
The scheduler always says refreshing
And the data source looks as per below.