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.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
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
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.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
@minty
Sample Db is in one of the posts called test.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
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.
Cheers,Code: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;
Format([Date],"mm/dd/yyyy") almost got me there. Now the date picker is disabled.
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
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?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba