How to read CSV file date and display at TAB ?

[Anonymous]

Hi All

My CSV file store at sharepoint , can PBI read the file date and display the date at PBI ? So that i aware the latest raw data update date.

Paul

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[StefanoGrimaldi]

yes you can do this, simply connect to your root sharepoint web url, navigate till you finde the folder or file you looking for but dont open the file itself, you will noticethere you have the data as a table of each file here you can get this you looking for: 

result: 

[Anonymous]

Hi Stefan

I just goole and found below link , mean I need to modify my M code , in order to get the date info :-

https://community.powerbi.com/t5/Desktop/new-column-from-import-file-timestamp/m-p/549396

Are you able to help me modify my M code ?

https://www.dropbox.com/s/uncyvpb0s08babp/PBT_V2021_112%20How%20to%20get%20date%20info.pbix?dl=0

My PBI file

Paul Yeo

Paul

[Anonymous]

Hi @Anonymous 

You can get data from sharepoint twice by sharepoint folder in power bi desktop.

You can import table in first one into desktop and build your report by it.

Don't import second one and filter second one to show the date modified of the data source you use.

Query1:

Query2:

Result:

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

Hi Stefan

Yes , that is what i need. I notice that file date after load into PQ , the date appear , but once import to PBI , the date filed dis-appear , not sure how to get the date back ?

Paul Yeo

[StefanoGrimaldi]

strange doesnt dissapear for me, as the sample before, you just need to get to the field and load, didnt do anything diferent. 

[amitchandak]

@Anonymous , refer if one of these can help

https://www.poweredsolutions.co/2019/04/04/connecting-to-files-in-sharepoint-onedrive-with-power-bi-power-query/

https://community.powerbi.com/t5/Desktop/How-to-load-csv-file-from-Sharepoint-folder/m-p/85066

https://community.powerbi.com/t5/Power-Query/CSV-File-as-data-source-that-is-on-Sharepoint/m-p/43578

[Anonymous]

Hi Amit

I think i never explan clearly my requirement.

What i need is to know my raw data file " Date " as every CSV file will have date , so in case due to SAP never generate new raw data to PBI , i can check SAP why never generate new raw data file ? what i need is to read CSV file date. and display PBI.

if today 19/01/2021 and PBI display file date = 01/01/2021 , then i know my raw data never update for 18 days.

Paul