Publish to Power BI: Column was not found in specified table.

[Mert]

Hi. I am trying to publish a two columns table to Power BI however getting an error, which could be seen on the screenshot.

It seems like a specific error, hence could not find any suggestions anywhere yet. Any ideas?

[TheOC · Accepted solution]

hey @Mert 

It looks like its looking for a column called '<pi>Avg_Score_y</pi>' in the powerBI dataset- however i would imagine your field is called 'Avg_Score_y', both in the powerBI data and in the output of your summarize.

From what it appears - this is potentially a bug in the PowerBI tool - Although, it could just be how it is output.

The only other post i could find on this, was:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Getting-Error-when-trying-to-append-Re...

Which suggests that if you are trying to create a new table, make sure you are using the 'Create New' mode of the tool, rather than append.

Hope this helps,
TheOC