Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Nithyan

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

Submitted by on ‎05-22-2023 04:00 PM

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
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎05-23-2023 11:42 PM

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

Idea Statuses