SharePoint dates in Power BI

%3CLINGO-SUB%20id%3D%22lingo-sub-195546%22%20slang%3D%22en-US%22%3ESharePoint%20dates%20in%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195546%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20get%20data%20from%20SharePoint%20lists%20in%20Power%20BI%2C%20the%20dates%20are%20imported%20with%20a%20data%20type%20of%20%22any%22%2C%20and%20I%20need%20to%20manually%20change%20the%20type%20to%20date.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20make%20Power%20BI%20automatically%20identify%20date%20fields%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-195546%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormatting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Contributor

Hello,

 

When I get data from SharePoint lists in Power BI, the dates are imported with a data type of "any", and I need to manually change the type to date.

Is there a way to make Power BI automatically identify date fields?

0 Replies