OData authentication to Power BI Report Server shared dataset

My current Use Case:  A power BI (PBIX) report using Power BI Shared Data Source/Data Set created using Microsoft Data Builder and published on PBIRS Portal, with a Cache Refresh Plan created for the Shared Data Set on PBIRS Portal and a Scheduled Refresh setup for PBIX report on PBIRS Portal.

I want to circle back and let the thread know that this is working for me in September 2024. My org is running January 2024 Release of PBIRS. My settings/configuration look like this:

Shared Data Source (not the shared Data Set) is using SQL Server Internal Account for Authentication.

Then in the Settings of Shared Data Set on PBIRS Portal > Manage > Caching

Cache copies of this dataset and use them when available

Cache Expiration set for 6:00 AM everyday (using a Shared Cache Expiration Schedule)

Cache Refresh Plan created for a 6:01 AM refresh everyday (using a Shared Cache Refresh Schedule)

Then in the Settings of PBIX Report on PBIRS Portal > Manage > Data sources

Data Source <N>:

Type: OData (pre-selected drop-down value with non-functioning drop-down stuck at OData, which is understandable)

Connection String: As defined in Power BI Desktop while accessing the Shared Data Set in Power BI Desktop (Optimized for Report Server)

Credentials:

Authentication Type = Windows Authentication (from the drop-down on PBIRS portal)

User name: DOMAIN\Local-AD-Account

Password: <password for this local AD account>

is working for this.

One point I would like mention is: when I configured the data sources for my PBIX report, I did not Validate the connection for one of the data sources and the scheduled refresh for PBIX report failed for that data source. Once I went back to the data source settings of the PBIX and validated the connection for that data source, the refresh worked successfully.

I hope this helps someone out there!!

Regards, JP