Power BI , Word Files, and File Names

Question

Can Power Bi do the following?I have a large number of word documents (I also have them as Excel files but the formatting is better in Word).&nbsp; The documents are named 1 misc.doc, 2 misc.doc ......&nbsp;&nbsp;&nbsp;&nbsp; Each document has a title, in bold, at the very top of the document.&nbsp; But most documents have some misc. text, in one or two rows before the title, a few words such as "Print" or "Tools".&nbsp; I would like to remove these words, most importantly I would like to grab that title, in bold. &nbsp; For simplicity, let's call the new title:&nbsp; xTitle. Then rename or make a new file called 1 xTitle.doc&nbsp; (or similar in excel).&nbsp; The files do not have the same number of columns and a variety of different tables, etc.&nbsp; Their only commonality is the bold title at the start of the document.Thank you?Steve

amitchandak · Answer

se2 , Not very clear. But I doubt you can do that. 
In case you need some data, there is workaround suggested in this ticket refer : https://community.powerbi.com/t5/Desktop/Extract-tables-from-word-document/td-p/100632

se2 · Answer

Thank you.&nbsp; Would it be possible if my file were excel files or html files.&nbsp; To clarify:1. I have two folders, one with excel files, one with html files.2. The files are uneven. While they have columns, they have different numbers of them, so these are not excel files that can be "merged."3. The files are named in a way that does not show their content.&nbsp; This is the problem: 1 misc.xlsx ...4. Sometimes the 1st or 2nd rows contain a word or two that is irrelevant.5. By the 3rd row, there is a heading in bold.&nbsp; I would like to be able to grab this and rename the file with that heading.&nbsp; So 1 misc.xlsx becomes 1 MyHeading.xlsx6. Is is possible to write use dax or M to spool through the files and do the renaming or copying to new files with informative names?Steve&nbsp;&nbsp;&nbsp;

greg_deckler · Answer

se2&nbsp;While it *might* be possible, that is NOT a good use of Power Query, you should be doing that in a scripting language of some sort. I mean, if you were to do it, you would probably need R or Python steps I think. I'm really overall against this approach, I just think you need a better/different tool for this.
&nbsp;
ImkeF&nbsp;edhans&nbsp;do you agree? This leads down a rabbit hole of sadness and despair, right?

se2 · Answer

Just wanted to make sure I'm not wasting my time. In fact, I have the above finally done using FoxPro which can do a lot of what Python and are due. I have another question. I have six Excel spreadsheets, each one has a budget for one year, here one,… Through year six. Each one uses the same categories that is personnel, fringe, etc. Of course, because costs increase year by year, the costs in the year one budget are a little less than the costs in year two, etc. I would like to bring these budgets together into one budget sheet. In the left column, there would still be the same categories: personnel, fringe, etc. however, in column two, the header would be your one, in column three, it would be year to, etc. and I would be able to see the budget for the six years on one spreadsheet. Is there a way to accomplish this with power VI, or do I still need to go back to our Python or whatever? Thanks so much Steve

se2 · Answer

Sorry, with voice dictation, I misspelled year one, year two, year three, year four, your five, year six, so the resulting matrix will have, in column one, personnel, fringe, travel, etc.,

Forum Discussion

Power BI , Word Files, and File Names

5 Replies

Related content

Lakehouse File name

file name

Different Filed Name Between Power BI and Power Query

Can we donwload all pbi file names

Renaming a Power BI project file (.pbip)