Fetch data from a word file into the Power BI

[Shubham96]

I want to fetch data from a Word file which is on the Onedrive into the PowerBI..Also it should be dynamic if i make changes into the word file those should get reflected in the Power BI 

@amitchandak 

[Visharavana · Accepted solution]

Hi @Shubham96 
First of all, we can't connect a Word file to PowerBI. We have to convert to PDF or Excel these file types, then we can use in PowerBI. In dynamic changes is possible when connecting onedrive to power bi, just copy the url of the converted file in onedrive and use the web connector in the power bi desktop. 

[Anonymous · Accepted solution]

Hi, @Shubham96 

Thanks for Visharavana‘s reply. As Visharavana describes it, PBI Desktop doesn't support linking Word format files, you have to convert the word to Excel, etc. Here are some additions.

Support file:

Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn

Excel and OneDrive with Power BI For Collaboration (youtube.com)
Connecting to OneDrive through Power BI - YouTube
GET DATA FROM ONEDRIVE files the EASY WAY // Power BI Beginners Guide in 2022 - YouTube

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Visharavana · Accepted solution]

Hi @Shubham96 
First of all, we can't connect a Word file to PowerBI. We have to convert to PDF or Excel these file types, then we can use in PowerBI. In dynamic changes is possible when connecting onedrive to power bi, just copy the url of the converted file in onedrive and use the web connector in the power bi desktop.