Forum Discussion
Help, please!!.Error to refresh Semantic Model into workspace- "column doesn´t exist"
Hi, sorry for my delay in reply all of you.
Actually I guess all responses have been made of my thread might be correct as good practice.
But really what affect to my issue didn´t work, also because I didn´t mentioned that part of my source came of API web and there is what was the error.
Finally I found the problem, although i don´t know yet why....Let me explain:
In power query part code of API web, i might select where say " columns" and filter with sql code, and filtering columns i want to show... and that worked well in power desktop but when i uploaded to power service gave error of "column didn´t find"
So solution i found, was removing that part and showing all columns (writting * symbol)
-----
Paginas = List.Generate(
() => [offsetPage = 1, pages = 1, Data = {}],
each [offsetPage] <= [pages],
each [
response = Web.Contents(url,
[
Headers = [#"Authorization" = "Bearer " & accessToken,
#"Ocp-Apim-Subscription-Key" = "xxxxx",
#"columns" = "*", // don´t work in my API code selecting by specific columns....
#"offsetPage" = Text.From([offsetPage])
]
] develeoped:
......
Thanks
Super UserHi Hamp79
Try:
1. Republish the dataset from Power BI Desktop to Power BI Service and refresh again.
2. Check the data source credentials and access permissions configuration
3. Verify theData Source settings in Power BI Service
4. Try clearing cache
Regards,
Ritesh
Community Champion
Please mark the answer if helpful so that it can help others
Community SupportHi Hamp79 ,
If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.
We value your feedback, and it will help us to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Fabric Community Forum.
- v-aatheeque
Hi Hamp79 ,
Just checking in to see if you're still experiencing the issue with the missing column during the semantic model refresh. From your earlier message, it sounds like the column does exist and works fine in Power BI Desktop, which suggests the issue might be related to the dataset or schema differences in the service workspace.
If you’re still facing the problem, feel free to share any recent changes to the model, query structure, or source permissions — we’d be glad to help troubleshoot further.
If the issue has been resolved, kindly consider marking the helpful response as Accepted to guide others facing a similar scenario.
Looking forward to your response!
Hi, sorry for my delay in reply all of you.
Actually I guess all responses have been made of my thread might be correct as good practice.
But really what affect to my issue didn´t work, also because I didn´t mentioned that part of my source came of API web and there is what was the error.
Finally I found the problem, although i don´t know yet why....Let me explain:
In power query part code of API web, i might select where say " columns" and filter with sql code, and filtering columns i want to show... and that worked well in power desktop but when i uploaded to power service gave error of "column didn´t find"
So solution i found, was removing that part and showing all columns (writting * symbol)
-----
Paginas = List.Generate(
() => [offsetPage = 1, pages = 1, Data = {}],
each [offsetPage] <= [pages],
each [
response = Web.Contents(url,
[
Headers = [#"Authorization" = "Bearer " & accessToken,
#"Ocp-Apim-Subscription-Key" = "xxxxx",
#"columns" = "*", // don´t work in my API code selecting by specific columns....
#"offsetPage" = Text.From([offsetPage])
]
] develeoped:
......
Thanks