Yes, you can show the last modified date of Excel files stored in SharePoint in Power BI using the Power Query Editor and the SharePoint Online connector. Here's how you can do it:
Open Power BI Desktop:
Launch Power BI Desktop.
Get Data from SharePoint:
Go to the "Home" tab and click on "Get Data."
Choose "SharePoint Online List" from the list of data sources.
Connect to SharePoint:
In the "From SharePoint Online List" dialog, enter the URL of your SharePoint site where the Excel files are stored.
Click "OK."
Navigate to the Excel Files:
In the Navigator window, browse through the SharePoint folders to find the folder containing the Excel files you want to analyze in Power BI.
Select the folder and click "OK."
Combine Files:
In the Power Query Editor, you will see a list of files in the selected SharePoint folder.
Click on the "Combine" button in the "Home" tab and choose "Combine & Load."
Expand Attributes:
Once the data is loaded, you'll see a new column called "Content" that contains the Excel files.
Click on the double-arrow icon in the "Content" column header to expand the attributes of the Excel files.
Extract "Last Modified" Date:
Inside the "Content" column, you should see a column called "Date accessed" or "Modified Date." This column contains the last modified date of each Excel file.
Select the "Date accessed" column and click on the "Transform" tab. You can use the "Date" dropdown to set the proper date format if needed.
Close & Apply:
Click on "Close & Apply" in the Power Query Editor to apply the changes and load the data into your Power BI report.
