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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
sbowles
Regular Visitor

OData loses its credentials with OAuth2 when connecting to Dynamics CRM Online 2015 update 1

MSCrM and PBI Guru's

Loaded a custom MSCrm  data set to PBI .. It connects directly to Microsoft Dynamics CRM online 2015 update one via the Odata conection
.
I can't seem to get it to refresh! 
It's giving me a variety of failures.. Most specifically it can't connect to data( I have to reenter my credentials each time using Oauth2.) - The next day it loses it again...:-(
Org is setup on ADFS but my user for Oauth2 is outside the ADFS the using the .onmicrosoft domain

Useing a full PBI Pro License 

Other times; it gives me an error that says "an error occurred while processing the data in the data set"
I can't find anything wrong with it.. It refreshes okay from the desktop... (Although extremely slowly)

I have the standard CRM Odata feed and template set up and it's working fine ( PBI template that comes when you connect to the service)... Its Not losing my credentials and refreshes on a daily basis..

Tried manually refreshing... Getting a variety of strange errors coming back

"The last refresh attempt failed because of an internal service error"
"an error occurred while processing the data in the data set"
"can't connect to the data source".

Anyone else going through this hellish nightmare? I have a support claim in but nothing yet from the PBI fokes ..

1 REPLY 1
bpalermo
Frequent Visitor

Over the last month or so, I've been getting the same issue with scheduled refresh from CRM online.  Very annoying.  Previously, it had been working fine.

 

Did you get a response on this?

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.