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. 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
Thanks, but regretfully two first steps were checked, and nothing. I am feel stuck and lost, because I don´t see anything out of normal in power bi desktop.
The only error I see is in Service, but when refresh in desktop comes out well.
Because is not working, there is a difference somewhere. Make sure the credentials edited at Power Bi Service are the same one you are using for refreshing at desktop.
Regards