Central NJ Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
  • 1.  Data source setting

    Gold Contributor
    Posted Sep 08, 2018 10:36 AM
    Hello, here's a tip that someone asked me about this week.

    How to change the data source setting in PBI to use a data file saved in an Office 365 library.

    Go to the O365 library that has the file.

    Copy the URL, which may look something like this (from my O365).

    https://yoursitename.sharepoint.com/sites/yourworkspace/Shared%20Documents/Forms/AllItems.aspx

     

    Shorten that to:

    https://yoursitename.sharepoint.com/sites/yourworkspace/Shared%20Documents/

     

    This should be the root for the files.  Use this plus the file name for each data source.

    https://wraparound.sharepoint.com/sites/tcom/Shared%20Documents/name-of-datafile.csv

     

    Another way to get the path is to open the file in Excel from the O365 library.

    Click File, and under Info, see the name of the file, below that you see the path.

    Copy that.  Delete the 6 characters at the end, after csv – it will be something like ?web…

     

    Either method works.



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