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 Hamp79
1. Verify Data Source Credentials in Power BI Service
Go to Power BI Service → Workspace → Dataset Settings → Data source credentials
Make sure the credentials are valid and have permission to see the column/table.
2. Check Gateway Settings
If your source is on-prem, ensure the Gateway is configured properly, and the data source is mapped correctly.
Go to Power BI Service → Manage Gateways → Verify the source is listed and working.
3. Check for Column Use in DAX Measures or Visuals
Even if the column exists in the model, it may not exist in the source table during refresh.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
Hi Hamp79 ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If the response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Thank You.