Pivot table with multiple data sources

Summary

Pivot table is not getting populated with data, If we use multiple data sources

Content

Hello,

We are trying to create BI report template using pivot table option in MS word .

Issue is pivot table is not populating with data in MS word, if  we use  multiple data sources in the pivot table.

We are following below steps to create the report template, Can anyone please advise us what we can do to populate the data in the pivot table please.

-Created data model(using multiple data sources).

-Loaded Data model to MS word through "BI publisher" option  and saved it to .rtf file.