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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Goulutor
New Member

Data sources credentials and report publishing

Firstly, I'm new in the world of Power BI as you will see below.

 

*Context:*

We would like to setup a Power BI Report Server infrastructure with import model (no DirectQuery).

We have already configured:

- a new Power BI Report Server which is working

- Kerberos is enabled so that the end users can access the reports on the web front of Power BI RS

- the BI experts use Power BI Desktop to build their reports and publish them to Power BI RS

- those BI experts use basic authentication for the datasources

 

*Constraints:*

- According to our policies, we cannot use on-premises Active Directory to access data sources (only Azure AD with SAML or OIDC; Kerberos for Power BI RS is an allowed exception) ; therefore we use basic authentication for datasources.

 

*Needs:*

- the BI experts need to publish their reports to Power BI RS without changing the data sources credentials after the publishing.

 

*Questions:*

- Is there a way to configure the data sources credentials only on Power BI RS side? I looked at the "scheduled refresh" and "stored credentials", but not sure it fits our needs.

- Is the Power BI RS platform able to connect to datasources using its service account?

- Or do we have to build something specific (using scripting on our CI/CD plateform for example)?

 

Thanks

0 REPLIES 0

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors