Forum Discussion
Community ChampionCan't update my Semantic Model in Fabric. Getting Errors
This is the first time i have attempted to create a Semantic Model in Fabric. (Direct Lake Mode on Delta PARQUET)
Every time I try and do a simply thing. like Joining a key in a fact table to a key in the dimension. I get errors
Something went wrong
The changes didn't work, so we've reverted your model to a working state. Try again.
- Underlying Error{"batchRootActivityId":"94c4366d-9eb6-46b2-8ce8-9d3fd2174b76","exceptionDataMessage":"Default dataset rebuild operation encountered user error: 'We cannot access source column '<ccon>series</ccon>' from delta table '<ccon>dimepisode</ccon>' of table '<ccon>dimepisode</ccon>'. Either the source column does not exist, or you don't have access permissions. Consider removing the invalid column references from the table in the model. Please refer to https://go.microsoft.com/fwlink/?linkid=2248855 for more information.'"}
- Activity IDbab7574c-7556-4c2d-961a-45e5df499bd5
- Correlation ID9817c30b-029b-c1f7-994e-f811a4cea0db
- Request IDa2c051ee-8929-2969-1e29-8aa5e8741ad3
- Status code200
- TimeWed May 29 2024 09:44:49 GMT+0100 (British Summer Time)
- Service version13.0.23358.46
- Client version2405.3.19359-train
- Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net/
its definitely there. I dont know how to get past this issue?
As an update. i came back from a break and relationships were there. But there were two identical joins on fact keys to dimensions showing. Both Live. I tried deleting and got the error again. Then it reverted back to the incorrect state
It seems incredibly bug ridden to the point of being unuseable. Is this the case of can I do something my side?
2 Replies
Hi, DebbieE
According to the error information, you can check if the following steps solve the problem.1. Ensure that the column 'series' indeed exists in the delta table 'dimepisode'. You can do this by querying the table schema directly in your data environment. If the column does not exist, you'll need to adjust your model accordingly.
2. And you need to check if you have the necessary permissions to access this column. This involves checking the access permissions on the delta table and ensuring that your user account or role has the appropriate rights.Manage semantic model access permissions - Power BI | Microsoft Learn
3. Look at the model relationships and make sure that each relationship is defined correctly and that there are no unexpected duplicates.Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
- DebbieE
This wasnt the fix for this. it turns out the default semantic model isnt that usable at the moment so i had to create one from scratch
