Forum Discussion
Power BI Model - Fabric
Community SupportHi Sanju_BI,
Thank you for reaching out to us and providing detailed information about the thread. Also thanks for DataNinja777, for his inputs on this thread.
The behaviour you are experiencing is due to Power BI Desktop caching the metadata schema when connecting to a Fabric semantic model via Direct Lake or Live Connection. Although you have updated the field type from Date Time to Date in the semantic model, Power BI Desktop may not immediately reflect these schema changes unless a full metadata refresh is performed.
This is a known limitation when schema-level changes are made directly in the Fabric model but are not propagated into the Power BI Desktop metadata cache.
To clear the metadata cache in Power BI Desktop, follow these steps: Close all Power BI Desktop files. Open Power BI Desktop, then navigate to: File > Options and settings > Options. Under Global > Data Load, click on Clear cache. Ensure that “Store datasets using enhanced metadata format” is enabled under Global > Preview features (if available). Restart Power BI Desktop. Open your PBIX file, reconnect to your Fabric semantic model, refresh the report, and verify if the date_entered field now displays in the Date format.
Reconnect using a new PBIX file for testing: Create a new Power BI Desktop file and connect it to your Fabric semantic model. Verify if the date_entered field now appears with the correct Date type. If it does, the issue in the original file is likely due to stale cached metadata.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
Community SupportHi Sanju_BI,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
- v-kpoloju-msft
Hi Sanju_BI,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.- v-kpoloju-msft
Hi Sanju_BI,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.