Data sources credentials and report publishing
Firstly, I'm new in the world of Power BI as you will see below. *Context:* We would like to setup a Power BI Report Server infrastructure with import model (no DirectQuery). We have already configured: - a new Power BI Report Server which is working - Kerberos is enabled so that the end users can access the reports on the web front of Power BI RS - the BI experts use Power BI Desktop to build their reports and publish them to Power BI RS - those BI experts use basic authentication for the datasources *Constraints:* - According to our policies, we cannot use on-premises Active Directory to access data sources (only Azure AD with SAML or OIDC; Kerberos for Power BI RS is an allowed exception) ; therefore we use basic authentication for datasources. *Needs:* - the BI experts need to publish their reports to Power BI RS without changing the data sources credentials after the publishing. *Questions:* - Is there a way to configure the data sources credentials only on Power BI RS side? I looked at the "scheduled refresh" and "stored credentials", but not sure it fits our needs. - Is the Power BI RS platform able to connect to datasources using its service account? - Or do we have to build something specific (using scripting on our CI/CD plateform for example)? Thanks
Report Server stored credentials - Couldn't connect
Hi all, I have a report that connects to a Microsoft SQL 2014 database using database credentials. It works fine when running in Power BI Desktop, but when I deploy the report to the server and try to store the data source credentials to schedule a refresh I get the following error: "Couldn't connect. The report server couldn't connect to the data source using the information you entered..." Further details are: "Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error:0 - The message received was unexpected or badly formatted)" We are running the August 2018 version of Report Server, and the data refresh works fine in the August 2018 RS version of Power BI Desktop. I have tried turning off the "Encrypt connections" option in the report but get the same result. Any ideas? Michelle