can't connect to sql data

2 Topics

How to change the SQL server datasource on a published report?
Hi all, I'm pretty new to PowerBi and here's my situation, hoping to avoid this setup (or mistake) in the future: - I created a report that connects to my local SQL server and its database, everything works and the report is done. - I have published the report to a workspace. - I have setup the on premise data gateway on another machine that is running the target SQL server and its database. This is configured and up and running on my PowerBi portal, all good on this part. - If I want to refresh my published report it fails, but that's normal because there is no connection to the dataset. - In the settings of the semanctic model the datasource refers to my local SQL database connection, lets say SERVER-A;Database1 Desired result: The published report should be connected to a different SQL server (SERVER-B;Database1), the one that is accessible through the gateway. The database remains exactly the same. I just worked on a copy of it on my local machine. How can I point my report to the correct server to fetch its data? Much appreciated if anyone could help 😎 Thanks!
Solved
unknown_object
2 years ago Place Report Server
1.2KViews
0likes
3Comments
Report server couldn't connect to the data source
Hi, I am unable to connect to a SQL data source in report server using an account that previously worked. I can connect to the SQL server in power BI desktop using the account, same credentials. I can connect to the datasource in report server using other accounts that have the same permissions on the database. The error I receive is: The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly. Credentials and connection string are correct. Has anyone encountered this before? I need to use this account to authenticate all data sources as it is a service account that does not have a password reset policy assigned. Kind regards
wardy912
3 years ago Place Report Server
2KViews
1like
2Comments