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

[cindex-admin]

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.

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?

[Anonymous]

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]

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

[cindex-admin]

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.