Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

D365 FO/ Datalake / CDM / PowerBI

Hi all,   We've set up a datalake connecting to D365, and are now connecting to this through PowerBI - all the data comes through and at a glance everything looks great.   When connecting as file...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Could you provide some error messages from like
if i change the format to text (string) or a different date format the data still comes through as an error.

and:

2022-05-16T00:00:00.0000000 - i've changed this to a more suitable format, or text but it still shows an error 

 

If your connection mode is Import, you may change the data type in Power Query after loading original data.

For more information, please refer to:

Data types in Power Query - Power Query | Microsoft Docs

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

     

    Thanks for your response!

     

    Error message from Power Query:

     

    "DataFormat.Error: We couldn't parse the input provided as a Date value.
    Details:
    2022-05-16T00:00:00.0000000"

     

    This is the same error whether the datatype is set as Date, Text, DateTimeTimezone etc.

     

    I opened the query in FileSystem mode, rather than CDM and found the relevant JSON.

    It shows dataFormat as "Date".

     

    Thanks