Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Anyone have experience with Power BI publisher/Excel and connecting to datasets in the service?
We have some datasets using Import mode. We've set the data types like date, $, etc in the dataset. Once we connect to the service through publisher the dates look right, but Excel shows as "General". We can't sort Oldest to Newest or change the type.
Thoughts?
@Aron_Moore,
This is a PowerPivot issue, please check my reply in the following similar thread.
http://community.powerbi.com/t5/Integrations-with-Files-and/Analyze-in-Excel-Date-field-issue/m-p/14...
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.