Connection Business central onprem with Power BI services with API Query

(0) Share

Report

Posted on by Community Member

Hi, I m developing reports data coming from Business Central, using AL language and creating API Query object. I m able get data using a URL with webkey, however after publishing datasource to Power BI services adding credential (the same what is working OK on desktop version) I got a error

Failed to update data source credentials: OData: Request failed (404): The remote server returned an error: (404) Not Found. (Cannot process the request because the default company cannot be found. You can specify a default company in the service configuration file, or specify one for each tenant, or you can add a query string in the form of "company=[name]". You can see the available companies by accessing the default OData web service, Company.

Any idea how to configure the connection string to be able update data from Business Central

Igor

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

MahGah 15,581 on at

Like (0)

Report
Copy link

Link copied!

Hi

I am sure you already checked this. But can you go to Power Bi Workspace then for the dataset you use for this report go to settings and then Parameters and see if you can see the company name there? it should match the company name in BC that you designed the report for.

Was this reply helpful? Yes No