Central NJ Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

adding text to a power bi text box

  • 1.  adding text to a power bi text box

    Posted Feb 21, 2020 01:09 PM
    hello guys, i was wondering if there is a way to add/insert in a power bi text box the text inside a .txt file,   it has to be inserted from a text file that is located in a shared folder because some co-workers are going to update the .txt file info very often and the text inside the text box must be update with just click in refresh button, any ideas?

    thanks in advance!

    Regards.

    ------------------------------
    Pedro Fernando Ortiz Mira
    Specialist, operations Servicing

    ------------------------------


  • 2.  RE: adding text to a power bi text box

    Gold Contributor
    Posted Feb 21, 2020 02:46 PM
    Hi Pedro,
    I've done some work with narrative-text data.
    Is it critical that the text from the .txt file display inside the power bi text box?
    for example, if you could bring the text from the .txt file into the power bi report in some way and so that it will refresh -- is that good enough?

    ------------------------------
    Jerome Scriptunas
    Central NJ PUG
    ------------------------------



  • 3.  RE: adding text to a power bi text box

    Gold Contributor
    Posted Feb 21, 2020 04:13 PM
    Pedro, here is a simple test of updating data in a *.txt file that displays in a table visual in Power BI.
    I was able to add text to the txt file, save, go to Power BI, refresh, and see the result.
    The formatting can be improved by merging columns or using other transform functions in the Query Editor.

    https://tinyurl.com/gettxtfile



    ------------------------------
    Jerome Scriptunas
    Central NJ PUG
    ------------------------------



  • 4.  RE: adding text to a power bi text box

    Posted Feb 21, 2020 05:16 PM
    i think this is what i was looking for Jerome i looked for that narrative-text data and found that there is like an add-on for power bi called narratives for pbi unfortunatelly that add-on is no longer in use for pbi but i found another called arrianlg that supposely works the same, now i just have to figure out how it works lol, have you heard about it?
    thanks a lot for all your suppor Jerome.

    Best regards.

    ------------------------------
    Pedro Fernando Ortiz Mira
    Specialist, operations Servicing
    ------------------------------



  • 5.  RE: adding text to a power bi text box

    Gold Contributor
    Posted Feb 21, 2020 06:10 PM
    Pedro, arrianlg is very interesting!  i was not aware of it and will read about it this weekend.

    i cleaned up the simple TXT example and posted it at PBITXT

    on the side, i'm working on a web app that will look at conversation and pick out keywords, questions, and relative participation then send it through Power BI to give a visual display of the communication (or lack of it).  I've been thinking about this for a long time and hopeful that with using some of these new tools that work with Power BI I might have a prototype by next year.

    please keep me posted on how things are going for you and whether the simple PBITXT example is useful.  i can send you the PBIX file, very simple.

    ------------------------------
    Jerome Scriptunas
    Central NJ PUG
    ------------------------------



  • 6.  RE: adding text to a power bi text box

    Posted Feb 25, 2020 12:38 PM
    Hi Jerome, hope you are doing fine

    Im still not able to insert the text in power bi :( , all the tutorials about it use a power bi extension named narratives for power bi, but it seems that extension is no longer available , i tried to search for it many times and i cant find it, anyways i was checking your previous answers and how did you do this? : https://tinyurl.com/gettxtfile

    perhaps i can add the url in the text box with "insert link" button that it has and it pop up the info in a internet browser tab just as you did with that example you sent me, thanks in advance!

    Regards.

    ------------------------------
    Pedro Fernando Ortiz Mira
    Specialist, operations Servicing
    Huixquilucan
    ------------------------------



  • 7.  RE: adding text to a power bi text box

    Gold Contributor
    Posted Feb 25, 2020 03:02 PM
    Hi Pedro, I sent the PBIX and TXT file to you directly.
    Should work if you reset Data Source Settings.
    Tell me if they did not get thru. If not I can share the files for download.

    Good luck, Jerome

    ------------------------------
    Jerome Scriptunas
    Central NJ PUG
    ------------------------------



  • 8.  RE: adding text to a power bi text box

    Posted Feb 25, 2020 03:52 PM
    yah got them, let me try it and let you know, thanks a lot Jerome :)