Report Builder / semantic model / workspace query

Hi simondavis1970 ,

Yes, what you’re seeing is expected behavior. For paginated reports, deployment pipeline data source rules function differently compared to standard Power BI reports. These rules only allow you to adjust the connection details, but you can’t browse workspaces or select a semantic model by name.

That’s why

1. You only see endpoints like pbiazure://api.powerbi.com/ and database names that look like GUIDs

2. Choosing Other just lets you edit these values directly.

3. There isn’t an option to pick a workspace or semantic model.

This is a current limitation of paginated reports in deployment pipelines, so you’re not doing anything wrong.

As a result, pipelines can’t automatically switch a paginated report from a UAT semantic model to a Prod semantic model. The main options are to either.

1. Maintain separate paginated reports for each environment.

2. Manually update the data source in Report Builder and publish the report directly to Prod.

Helpful reference 

Re: Paginated Report and Deployment Pipeline datas... - Microsoft Fabric Community

I hope this clarifies things and helps you.