.csv Dataset Chart sorting

[Azomite_Nathan]

Please advise,

I have a datalogging system that stores a .csv file into my Sharepoint folder every 10 min.  I can import the file as a dataset.  The problem arrises when I create a line chart in my report with local time as the x-axis, the time is not sorted in chronolgical order, it seems to be sorted in alphbetical order (i.g. 1:57 PM, 10:07 AM, 12:57 PM, 2:07 PM).  I have tried to format the cells in the .csv file as time, but that does not seem to make a difference.  Data import to Bi Desktop works correctly, but I am trying to take advantage of the OneDrive auto refresh to keep my data as close to real time as possile.

[Anonymous]

I would look at modifing your query. Look at the following references:

Option1: DateTime:Time

https://msdn.microsoft.com/en-us/library/mt253493.aspx

Option2: #datetime

https://msdn.microsoft.com/en-us/library/mt742858.aspx

Change the field or create a copy of the same field and try to use one of the funtions above. See if this helps!

[Azomite_Nathan]

Thanks for the reply.  I may be going about this problem the wrong way, but I believe the dataset from a file in Bi Service is a connection not a query and I do not see any options to modify the dataset after import.  As mentioned Bi Desktop gives me the query options I think you are referring to, and maybe I should be using Desktop rather than Service, but as for now the OneDrive auto update is what is pointing me to use Service.  It was also giving me some issues with not bringing in the "sum" of some of my data points until I edited the column in the csv file from general to number. Thanks again and any other advice would be appreciated.

[Anonymous]

You are on the correct path. I think Power BI Desktop client to create what you need in this case would better suite your needs. You want to create the query so that you will be able to refresh the report and not modify the data each time. The report arranges the data how you need to transform it in a way that makes it usable through power query.