topic Re: PBI RS Direct Query to SQL server with sql credetials in Report Server

PBI RS Direct Query to SQL server with sql credetials

Efy — Sun, 19 Nov 2017 16:52:40 GMT

Hi,

I have installed PBI RS (October 2017) on a machine with MSSQL 2016 for RS database.

I am developing a report with PBI desktop for RS (October 2017) with Direct query mode, the direct query is against a SQL database in our premise network, connecting with SQL credentials (SQL user).

The report is working fine on PBI Desktop of the developer.

Although we are not able to save to the RS service, we were able to upload the report to the RS portal from the developer's machine (thru the webpage).

The Power BI service is configured to run with my 'superuser' credentials, and I am able to see the report thru the link to the RS portal, but no one else is able to see it thru on the browser, the error message claims that there is a problem with the connection string to SSAS (my data source is to SQL Server).

Any Ideas?

Thanks,

Efy

Technical Preview of Power BI Reports in SQL Server Reporting Services

Efy — Thu, 16 Nov 2017 17:49:27 GMT

Hi,

For some reason only the user that we used as the "service account" to the PoweBI service is able to view reports, all the others get the error "can't connect to the analyses service, please check the connection string".

What is it means?

Thanks,

Efy

Re: PBI RS Direct Query to SQL server with sql credetials

v-yulgu-msft — Mon, 20 Nov 2017 08:53:56 GMT

Hi @Efy,

Did you grant proper permission to other users to enable them to access Web Portal and Reports?

Setting System-Level Permissions

Setting Item-Level Permissions

Regards,

Yuliana Gu

Re: PBI RS Direct Query to SQL server with sql credetials

Efy — Mon, 20 Nov 2017 11:07:13 GMT

Hi,

Thanks for your reply,

I should of mention that I gave those permissions, I gave one user high permissions and assigned to him all available roles, no success 😞

Please help.

Thanks,

Efy

Re: PBI RS Direct Query to SQL server with sql credetials

Efy — Tue, 21 Nov 2017 12:07:04 GMT

I have changed the service account to work with NetworkServices, did not help.

I saw that I configured in the past Execution Account to my user, I changed it back to the default (unchecked "Specify an execution account") and it works now.

Thanks!

Re: PBI RS Direct Query to SQL server with sql credetials

Anonymous — Tue, 21 Aug 2018 13:57:57 GMT

Hi @Efy sorry for bothering you back to this.

I am in trouble with the same thing you were, but I have never checked the "Specify an execution account" option. I uploaded on RS a report I created with my PBI Desktop using data with Direct Query mode from a SQL Server database, I am able to see it with administrator account but not with any other account.

I don't know why.

Can you help me?

Thanks

Nick