CODEWITHSUNDEEP
sqlazurereporting-services
Tony
Tony

Reputation: 149

Running SSRS report against Azure SQL

We're converting our SSRS reports to run against Azure SQL DB. They were previously run against on-prem SQL DB. We ran into an issue where we simply cannot run the reports from Visual Studio. We're getting an very generic error (An error occurred during local report processing). When I simply run a query in a Dataset query window, it returns the data with no issues. It's when I preview the report in visual studio, I get this error. Is anything extra needed to configure this Azure SQL DB?

Thanks.

Upvotes: 0

Views: 96

Answers (1)

Leon Yue
Leon Yue

Reputation: 16401

Congratulations Tony has solved the problem by himself:

"I solved it by using shared datasource instead of a local one."

I help him post it as answer, this can be beneficial to other community members.

Upvotes: 1

Related Questions