How to remove the timestamp from date field

[Welshgasman]

Sorry, I didnt mean to cross post but I sense your patience is running thin with so many post. Just trying to figure this out.

Not really, if I went to the trouble of downloading and installing PBI, then connecting to your test db from PBI.
That was as far as I could go, as I have no knowledge of PBI.

[Sonyat810]

I have a linked csv file that feeds to power BI. I am using access databse for the user interface. to feed the linked .csv file, but when I open power bi the date is missing because it doesnt ecpect the timestamp. I am trying to program the control source for the date using DateValue and Format. When I open the actual csv file I am still seeing the time stamp

[Minty]

Can you up load a sample of the original csv?

I have played around with Power BI and SQL data sources and there wasn't an issue, so I'd be amazed if it can't function with a link to an access table with a datetime field, or a even an access query.

[Welshgasman]

@minty
Sample Db is in one of the posts called test.

[Gicu]

This is a very old problem with the export specifications, I suggest you export it as a short text as suggested in some of these links (this is the Google search I used:https://www.google.com/search?q=acce...ome&ie=UTF-8):
https://www.access-programmers.co.uk...e-time.140835/
https://www.access-programmers.co.uk...-wrong.287065/
https://www.access-programmers.co.uk...t-time.117897/
So simply wrap the [Date] field (you should rename it as suggested multiple times) in a Format([Date],"mm/dd/yyyy") in a query based on the original table and export that instead.

SELECT LD_Master.ID, Format([Date],"mm/dd/yyyy") AS ExportDate, LD_Master.Area, LD_Master.[Liquid Amount (Gallons)], LD_Master.Comment, LD_Master.[Site Type], LD_Master.Street, LD_Master.City, LD_Master.[Zip Code]
FROM LD_Master;

Cheers,

[Sonyat810]

Format([Date],"mm/dd/yyyy") almost got me there. Now the date picker is disabled.

[Sonyat810]

I fixed it. I just re-imported my csv file and for date I picked short text and that did the trick. Thank you for all your help

[Gicu]

[Welshgasman]

I just downloaded PBI to a faster PC and installed it.
Using your test db I connected to it from PBI and data came in fine? See the pics, left is PBI, right is Access query.

So no idea why you are playing around with a csv file pass on the data?