Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
colmac
Regular Visitor

Date (and Currency) Types not retained on Load to Excel

New user here.

 

I have a Power Query set up and I have changed data types as required.

 

Power Query.url.jpg

 

But when I Close and Load, each of thes columns appear in Excel as "General" data type.

What am I doing wrong? I've tried googling for answers, but so far not found anything suitable.

 

Thanks

Colin

 

Edited 28th to correct minor typo

 

1 REPLY 1
colmac
Regular Visitor

Has anyone got any thoughts on this problem? As a new user I cannot find a solution.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors