Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
mwstrb
New Member

ODATA O-Auth 2.0 working in PBI Desktop but not in PBI Service

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.

CleanShot 2024-09-24 at 14.08.22@2x.png


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.".

CleanShot 2024-09-24 at 14.06.15@2x.png

If I now click on "Edit credentials" and authenticate myself again using O-Auth 2.0, I get the following error message:

CleanShot 2024-09-24 at 14.07.01@2x.png

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

CleanShot 2024-09-24 at 14.07.54@2x.png

3 REPLIES 3
v-zhouwen-msft
Community Support
Community Support

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...

mwstrb
New Member

Update:

- yes it is a complete fresh report

- yes i use the same account in both scenarios

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.