Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

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?

 

Status: Investigating

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

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

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