Forum Discussion
Help, please!!.Error to refresh Semantic Model into workspace- "column doesn´t exist"
- 1 year ago
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. If you have checked that the column exists with an external DBMS quering the exact same table/view and the column is right there, the next step is checking the permission for the login account at Service. Column can be hidden for users as a security purpose. If the credentials used for that don't see the columns it will fail even if it really exists.
If the problem is still there, you will need to open it in query editor power bi desktop and check step by step at which step is failing and why.
I hope that helps