Forum Discussion

Alberto104's avatar
Alberto104
Regular Visitor
5 years ago
Solved

Create a dataflow with Business Central data

I'm trying to create a dataflow with some data from Business Central. With Power BI Desktop there is a specific connector, but for Power BI Service and dataflow there is none. I have only found an OData connector.
I have tried to connect to an url like this:

 

https://api.businesscentral.dynamics.com/v2.0/...../Production/ODataV4/Company('NAME')

 

but Power BI recognized it as query and allow me to add only 1 table.
I just want something like Power BI Desktop to add all my tables.
Is the url wrong? Is there another way to create a dataflow from Business Central?

 

Thanks.

2 Replies