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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Power Bi Paginated Report Builder in MS Fabric Lakes Environment - Need to add columns from Data Sou

I am a newbie (26th dayin Trial status) to Power Builder Bi Report Builder. I have succeeded in daily uploading 25 tables from Azure environment to MS Fabric Lake House. Attached is screenshot of a paginated report layout I have built so far.

cindexadmin_0-1728057369344.png

To meet additional user requirements, I need to add two fields from tables not in the current report dataset1, as included in Dataset2.  How do I get the additional fields added to the report layout and/or to dataset1?

 

 

Status: Needs Info

Hi @cindex-admin 

So what you are saying is that you are currently using columns from dataset1 and now you need to add columns from dataset2 in your paginated report, right? What are your dataset1 and dataset2 datasources?

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi @cindex-admin 

So what you are saying is that you are currently using columns from dataset1 and now you need to add columns from dataset2 in your paginated report, right? What are your dataset1 and dataset2 datasources?

 

Best Regards,
Community Support Team _ Ailsa Tao

cindex-admin
Regular Visitor

Yes, that is correct. I want to add columns from Dataset2. Both Dataset1 and 2 come from tables in same lake.

cindex-admin
Regular Visitor

Yes, I want to add columns from dataset11. Bot dataset1 and 2 come from tables in the same lake DBDashboard as shown in the screenshot.  Corporate_Ticket table is used in both datasets.