Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 55 | |
| 24 | |
| 12 | |
| 11 | |
| 11 |