Forum Discussion
semantic model can't find DateTable
I have developed a reprot a while back, and for some of the KPIs I grab them directly from a semantic model from another reprt.
It was working fine, but today there is an error
Nothing has been changed in the semantic model. It is still the same. But I can't see the KPIs anymore. Moreoever, I can't delete the the connection and recreate it. Everytime, I see the same error
can someone help?
I think I got it now
LocalDateTables sound like date tables added via Auto Date/Time
Somebody must have disabled auto date time in the semantic model you are reading from, and now your composite model cannot refer to them anymore
This might also explain the difficulty to disconnect and reconnect
Can you check with the model owner if this is what changed?
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
7 Replies
Power BI Does not find a table, you say nothing changed and of course we believe you but
to help you, we need the pbix connected to the data source, because something must have happened
You can use a cloud service and paste the link here
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
why can't I remove the connection? let's say I want to remove everything from that Live connection and recreate it
I think I got it now
LocalDateTables sound like date tables added via Auto Date/Time
Somebody must have disabled auto date time in the semantic model you are reading from, and now your composite model cannot refer to them anymore
This might also explain the difficulty to disconnect and reconnect
Can you check with the model owner if this is what changed?
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Could the dates table have been renamed? Also what do you mean by you can't delete the connection and recreate it?
Hi elimey ,
KPI's which have been connected directly from semantic model can recheck if those Tables/columns still available in the semantic modelHi elimey , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.
HI elimey , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.
