Forum Discussion

Test_1232's avatar
Test_1232
New Member
7 months ago
Solved

undefined

Hello, I am currently trying to connect a set of companies from my Business Central production environment to Power BI. There are more than 50 companies in the environment, and I would like to extr...
Need Help
Show and Tell
Tutorial Requests
  • rajendraongole1's avatar
    rajendraongole1
    7 months ago

    Hi@Test_1232-You cannot pull data from all Business Central companies in a single OData/API call. Business Central is company-isolated by design. However, you can automate the process so you don’t manually connect to each company.

    For best practices:

    1.Prefer API v2.0 over OData where available (better performance)

    2.Filter data early (date ranges, required columns only)

    3.Keep company identifiers in the final table

     

    Hope this information helps

     

v-dineshya's avatar
v-dineshya
Community Support
7 months ago

Hi Test_1232 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Regards,

Dinesh

v-dineshya's avatar
v-dineshya
Community Support
7 months ago

Hi @Test_1232 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Regards,

Dinesh