Forum Discussion

Rbailey1959's avatar
Rbailey1959
Frequent Visitor
8 years ago

Paginated report subscriptions in Power BI Report Server (PBRS)

I am trying to create a report subscription against an RDL that I published to Power BI Report Server (On Premise). The data source for the report is a SSAS tabular model. When I try add a New Repor...
Jon-Heide's avatar
Jon-Heide
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Yes, you'll need to edit the data source credential after publishing the report. Either to store you user/pass information in the server or enabled the unattended exeution account. When the server runs subscriptions against AS, it needs to have the identity of the user. See  

 

https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/configure-the-unattended-execution-account-ssrs-configuration-manager

 

https://docs.microsoft.com/en-us/sql/reporting-services/report-data/store-credentials-in-a-reporting-services-data-source

 

 

Rbailey1959's avatar
Rbailey1959
Frequent Visitor
8 years ago

Thanks. It did come down to errantly using an imbedded data source vs a shared data source. Although some nuances need to be addressed the articles you pointed to got me well on my way to overcoming my ignorance.