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.
Hi
I am currently working on a composite model in Power BI Desktop, where I combine a cooperate SSAS tabular model with an excel sheet, placed in our Azure Data Lake. I am facing some problems, and hope that you can help me:
When I change some fields in my SSAS tabular model, it seems that I am not able to refresh the data in the Power BI Desktop. It comes with the following error messages "DirectQuery to AS - NAME. The model doesn't have a measure named xxx" or "Couldn't load the data for this visual. OLE DB or ODBC error: Query (3,7). Column xxx in table xxx cannot be found or mat not be used in this expression". How do I get it to refresh the data from my SSAS tabular model, without starting all over on my composite model?
Solved! Go to Solution.
This is not a data question, it is a meta data question. "How can I tell Power BI that my SSAS data model has changed?".
I think it has a lot to do with caches. Try clearing out all caches in Power BI desktop and then refresh.
Hi @dkmahf ,
If you direct modify fields name on data model side, these new field name cannot match with datasource fields(power bi not support to write back to database), so you had to use query editor to rename original field names or change it on database side.
Similarly, if you refresh the changed data source directly on data model side, you will also get this type of error. Try to refresh the data source in the query editor and apply it.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is not a data question, it is a meta data question. "How can I tell Power BI that my SSAS data model has changed?".
I think it has a lot to do with caches. Try clearing out all caches in Power BI desktop and then refresh.
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.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |