Blog Post

Power BI Community Blog
2 MIN READ

Power BI Paginated Reports with Custom Code (VB Code)

AbhiSSRS's avatar
AbhiSSRS
Icon for Solution Sage rankSolution Sage
5 years ago
With the buzz around Power BI Premium Per User Licensing going to General Availability at just $20 in April, this may be a time to witness an acceleration in Power BI Paginated reports development as...
Updated 5 years ago
Version 2.0
How To
Paginated Report Builder
Paginated Reports
Power BI Premium Per user
Tips & Tricks
AbhiSSRS's avatar
Icon for Solution Sage rankSolution Sage
Joined July 27, 2016
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
AbhiSSRS's avatar
AbhiSSRS
Icon for Solution Sage rankSolution Sage
5 years ago

Hi! I think you may use the built in Lookup function instead of custom code. 

Use Lookup to retrieve the value from the specified dataset for a name-value pair where there is a 1-to-1 relationship. For example, for an ID field in a table, you can use Lookup to retrieve the corresponding Name field from a dataset that is not bound to the data region.

=Lookup(Fields!SaleProdId.Value, Fields!ProductID.Value, Fields!Name.Value, "Product")