Config Report Service Use Data source

[Andre_Matsuoka]

Hi,

I use Report Service - Ver JAN 2020,  I using  Direct query, connecting SQL SERVER.

I need Pbix to use the user credential and password configured in the Data Source and don't use the data source file pbix settings,  how do I do ?

[d_gosbell]

Click on the ... menu for your report in the Report Server Portal, then go to Manage, then Data Sources and enter the username/password there.

[Andre_Matsuoka]

Thanks for the reply.
I don't want to configure the username and password within the report's data source.

I would like the Report to use the Report Service data source.

[d_gosbell · Accepted solution]

---

@Andre_Matsuoka wrote:

I would like the Report to use the Report Service data source.

---

You cannot do this, these only work with paginated reports.

[Andre_Matsuoka]

OK 

Thks