BUG : Odata web services from business central pulls all the column from source table.

[Nithyan]

Odata web services from business central pulls all the columns from the source table though columns are filtered in web services.

While pasting the web services in browsers only selected columns are shown as results.

But when pasting the Odata url in power BI pulls all the columns.

It works fine NAVISION not Business central.

Is there any way to make this work in the query itself and not by removing columns in Power BI manually?

[v-xiaoyan-msft]

Hi @Nithyan ,

To my knowledge, there is no better workaround.

If you would like to suggest  feature improvements, you may  vote the idea and comment here  to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Community Support Team _ Caitlyn