Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hey!
I would like to transfer a table from Business Central Cloud to PowerBI via ODATA API. In PBI Desktop, authorisation using O-Auth 2.0, downloading the data and updating the data works without any problems.
If I now publish the report and open it in PBI Service, the update no longer works. The semantic model settings are set to "Personal cloud connection" by default. However, in the "Data source credentials" section, I get the error message "Error testing the connection to your data source. Please try again with your credentials.".
If I now click on "Edit credentials" and authenticate myself again using O-Auth 2.0, I get the following error message:
If I create a new connection under the "Cloud connection" tab instead, this does not work either. I get the following error: Credentials are required to connect to ODATA source
Hi @mwstrb ,
If you have a Pro license you can open a Pro ticket at
Power Platform admin center (microsoft.com)
I think this will help you solve the problem faster.
Best Regards,
Wenbin Zhou
unfortunately, the support team has not yet found a solution either...
Update:
- yes it is a complete fresh report
- yes i use the same account in both scenarios
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
37 | |
26 | |
23 | |
19 | |
17 |