topic Re: Unable to Connect SQL server from Power bi Report Server in Direct Query mode in Report Server

Unable to Connect SQL server from Power bi Report Server in Direct Query mode

Anonymous — Mon, 02 Mar 2020 05:14:19 GMT

The import method works fine for SQL Server. However when i try to use direct query method, I'm unable to connect to the sql server from Power BI report server even if I manually enter the credentials. I'm getting "Password / User Name is incorrect" error. Someone kindly help me with this.

And is there any workaround for downloading the reoprts from report server as pdf from the report server?

Re: Unable to Connect SQL server from Power bi Report Server in Direct Query mode

d_gosbell — Mon, 02 Mar 2020 05:48:50 GMT

If you are trying to use Windows credentials and the SQL Server is on a different machine have you configured kerberos authentication? (see https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports )

When you tried entering the credentials did you try entering the username using the <domain>\<username> format?

Anonymous wrote:

And is there any workaround for downloading the reoprts from report server as pdf from the report server?

The only way to do this currently is to author your report as a paginated report. PBIRS cannot export to PDF directly from PBIX based reports at this point in time (as of the Jan 2020 release)

Re: Unable to Connect SQL server from Power bi Report Server in Direct Query mode

Anonymous — Tue, 03 Mar 2020 04:02:48 GMT

No , I havent tried to use KerBeros.I will be doing that once I'm able to establish connection to the database by at least manually entering the credentials .

Yes , I did use my domain Name as well but it didn't work.However it was able to connct to database when I made the connection to create schedule refresh for the reports i used Import method for.

Could you brief more about the paginated reports, do they behave like pdfs or are they interactive? Do we need a specific application to view them or create them.

Thankyou for your time

Re: Unable to Connect SQL server from Power bi Report Server in Direct Query mode

d_gosbell — Tue, 03 Mar 2020 04:38:21 GMT

Anonymous wrote:

Could you brief more about the paginated reports, do they behave like pdfs or are they interactive? Do we need a specific application to view them or create them.

They are more like PDFs, they can render out to a number of formats including Excel, CSV, PDF, etc. But they are aimed at fixed format, printable style reports not interact dashboards. The only interactivity is choosing from any parameters the report auther setup.

You only need a browser to view reports, but you need to user either Report Builder (free download) or SQL Server Developer Tools (SSDT) (also a free download) to get the SSDT designers you can download the community edition of Visual Studio and then get the Reporting Services extension (the community edition of VS has a special exception in it's licensing where companies can use it for the free with the SQL Server tools even if they are larger than the usual minimum size to qualify for the community licensing)

Re: Unable to Connect SQL server from Power bi Report Server in Direct Query mode

Anonymous — Tue, 03 Mar 2020 05:22:50 GMT

Thank you!! d_gosbell