Forum Discussion

MojoGene's avatar
MojoGene
Icon for Post Patron rankPost Patron
8 years ago
Solved

Show date last saved for excel file source?

One of the data sources in my data model is an Excel workbook. I would like to display the date that the Excel workbook was last saved. Is there an easy way to do this?
Need Help
  • fhill's avatar
    fhill
    8 years ago

    In Query Editor select 'New Source' and 'Blank Query'.  Next click Advanced Editor and past one of these options:

     

    If you data is local or on a network share:

    let
    Source = Folder.Contents("c:\temp")
    in
    Source

     

    If you data is on a sharepoint or One Drive folder:   (This one is easier if you go thru the Sharepoint option under Get Data - More, so PowerBI can record your credentials.)

    let
    Source = SharePoint.Files("https://<Org Name>.sharepoint.com/sites/<group Name>", [ApiVersion = 15])
    in
    Source

     

    Filter the results as desired to get 'Date Accessed' for the file you need.

     

fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
8 years ago

In Query Editor select 'New Source' and 'Blank Query'.  Next click Advanced Editor and past one of these options:

 

If you data is local or on a network share:

let
Source = Folder.Contents("c:\temp")
in
Source

 

If you data is on a sharepoint or One Drive folder:   (This one is easier if you go thru the Sharepoint option under Get Data - More, so PowerBI can record your credentials.)

let
Source = SharePoint.Files("https://<Org Name>.sharepoint.com/sites/<group Name>", [ApiVersion = 15])
in
Source

 

Filter the results as desired to get 'Date Accessed' for the file you need.

 

d1x0nl30ng's avatar
d1x0nl30ng
Frequent Visitor
7 years ago

i tried using the below in advance editor but returned below error. Any idea what went wrong or is it this method unable to go beyond Private folders in sharepoint ?

 

error when using below:

let
Source = SharePoint.Files("https://abcde.sharepoint.com/sites/AAA/BBB/CCC/Private/EEE", [ApiVersion = 15])
in
Source

 

no error when using below but my source file is few level below CCC

let
Source = SharePoint.Files("https://abcde.sharepoint.com/sites/AAA/BBB/CCC", [ApiVersion = 15])
in
Source

 

  • d1x0nl30ng's avatar
    d1x0nl30ng
    Frequent Visitor
    7 years ago

    So instead of using sharepoint.files , i added the source as sharepoint folder, up to before /private and filter the files from there. Managed to workaround this way.

    • DGA's avatar
      DGA
      New Member
      6 years ago

      Hello. My Excel file is on a Web link (dropbox link). How should the sintaxis be?

      Thank you!

      Diego