Forum Discussion
Need help connecting APIS by Odata method from Business Central to PBI
Hi Anonymous ,
Base on your description,it sounds like you’re encountering a permissions issue when trying to connect your custom API from Business Central to Power BI using the OData method. You can refer the following links to connect it in Power BI Desktop:
Enabling Power BI integration with Business Central - Business Central | Microsoft Learn
Connect to Power BI from Business Central on-premises - Business Central | Microsoft Learn
Reporting With OData Queries in Business Central – Part 1
In addition, Could you please check the following info for the further troubleshooting?
- Test API: Use tools like Postman or directly entering the OData URL in a browser to manually test the API endpoint. If you still receive a permissions error, reassess the permissions for the user and the API page.
- Ensure that you are using the correct OData URL and that the authentication method matches what is configured in Business Central When connecting to Power BI.
Best Regards
Thank you very much for your reply, I appreciate it very much.
All that you mention, I already tried it and it didn't work.
Trying things to rule out the problem, I found the solution by chance.
It turned out that my problem was in the objects IDs , which I had assigned as 50510,50511....
So it seems it could be a license problem or something like that, because I made again the apis to see if they worked, and when I made them again I assigned them an id 50060,50061,50062.... And they worked correctly at the first time.
I do not know if it could be a problem that I did not have so much range of objects in my license, but I tried to do everything, change the permissions of my user, create a specific permissionset for each api, and none of that was working. It was the ID problem.
Still, I thank you very much for your help and the complete answer you gave me. Im sure I will certainly post again if I have any more questions.
Regards!