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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Michaeldias
Helper I
Helper I

Can Power BI Report Builder use Perspectives?

I've created a Power BI model and set up Perspectives that can be used in Power Pivot.

 

Is there a way to change the connection to a Power BI dataset from within Report Builder so that only a specific Perspective is seen?

1 ACCEPTED SOLUTION
Michaeldias
Helper I
Helper I

Just found the answer in Report Builder Query Designer.
To see Query Deisgner Right Click your Data Source -> Add Dataset -> Query Designer

 

In Query Deisgner clicking on the ... where the default "Model" is displayed then other Perspectives that are present can be enabled

See pic1.png

View solution in original post

1 REPLY 1
Michaeldias
Helper I
Helper I

Just found the answer in Report Builder Query Designer.
To see Query Deisgner Right Click your Data Source -> Add Dataset -> Query Designer

 

In Query Deisgner clicking on the ... where the default "Model" is displayed then other Perspectives that are present can be enabled

See pic1.png

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.