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
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