Microsoft SQL: Invalid Column Name Error

[Anonymous]

Hello,

I noticed today that my Dataset in Power BI for my Dynamics F&O Reporting had not been refreshed in 4 days. 

Attempting to manually refresh, I get the below error:

Processing Error

I have attempted to utilize Azure Data Studio and Microsoft SQL Server Management Studio 18 to make changes, but I do not have my usual access. 

Is there another way I can troubleshoot this that may not require Admin access?

Or, do I wait for my DBA to get back from vacation? LOL!

Thank you for your time. 

[Anonymous]

Thank you, @GilbertQ!

The TSQL query did the trick and not I look like I know what I am doing! Haha!

Thanks again,

Natalie

[GilbertQ · Accepted solution]

Hi @Anonymous 

Either you could write a TSQL query which would not include the column "WorkerName" or wait for the DBA to get back to resolve the issue with the view!