Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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