Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

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?

1 ACCEPTED SOLUTION


@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)

View solution in original post

4 REPLIES 4
d_gosbell
Super User
Super User

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)

Anonymous
Not applicable

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


@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)

Anonymous
Not applicable

Thank you!! @d_gosbell 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors