Connect to Power BI Service Dataset With Microsoft Word

[jrieman]

How can I connect to a Power BI service dataset with MS Word?  Possible?  

[v-jianboli-msft]

Hi @jrieman 

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jrieman]

Our use case:  Currently, we have a process where an XML file is produced by an ETL tool (PDI).  After the file is placed in a shared location, MS Word uses the file as an input to pull in various financial figures, etc., into essentially what amounts to a template tailored to specific deals.  We'd like to remove our ETL tool, PDI, from the process and to essentially perform the same ETL in Power Query and then post the processed dataset to our Power BI service.  Once the dataset is posted to the Power BI Service, we need to export it to XML so that Word can use it as an input.  

I believe I can export to XML from a Paginated Report posted on the service but that same export option isn't available to Power BI reports  (I'm talking Power BI vs. Report Builder).   

Distilled problem:  Export a dataset from Power BI service to XML for ingestion into MS Word