Error: The column '' of the table wasn't found.

[rtran]

Hi! 

I'm getting the following "Underlying error message: The column '' of the table wasn't found." when I try to refresh in my workspace after publishing.. However, I have no errors and can load/refresh properly without any issues on my local .pbix file. 

Any ideas on why this is happening? 

Thanks!

[rtran]

Oh sorry, I mean the published version and the desktop version are using the same services and nothing has changed between the two. 

[parry2k]

@rtran it could be, maybe the new files/source you are using is missing some columns. Try using the same source in the Power BI desktop then the one you are using in the service and then check.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[rtran]

I added some tables, some with an old datasource and some with a new one and some with a url filter, which I merged with existing tables.. Does that affect it? 

[parry2k]

@rtran are you using any parameter to connect to a different source after you published to the service?

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!