Forum Discussion

mike_asplin's avatar
mike_asplin
Helper V
4 months ago
Solved

OData source error

Hi   I have amodle that did have some OData sources, but i changed them all to CDS sources. So now i just have CDS, shareoint excle files and a public website. Even so when I try to refresh in serv...
Need Help
  • mike_asplin's avatar
    mike_asplin
    3 months ago

    all good

mike_asplin's avatar
mike_asplin
Helper V
4 months ago

Maybe thaty other web source is this which someone help me put together to limit the amount of data being pulled?

 

let
    BaseUrl = "https://chaxxxx.api.crm11.dynamics.com",
    Endpoint = "api/data/v9.1/bookableresourcebookings",
    
    SelectColumns = "bookableresourcebookingid,_bookingstatus_value,_resource_value,name,_cha_clientid_value,_owningteam_value,duration,starttime,_cha_carercontactid_value,_msdyn_workorder_value,msdyn_totalcost,endtime,statuscode,msdyn_milestraveled,msdyn_actualarrivaltime",
    
    FilterDateText = DateTime.ToText(#"Load Date", "yyyy-MM-ddTHH:mm:ssZ"),
    
    QueryRecord = [
        #"$select" = SelectColumns,
        #"$filter" = "starttime ge " & FilterDateText
    ],
    
    Source = Json.Document(Web.Contents(
        BaseUrl, 
        [
            RelativePath = Endpoint,
            Query = QueryRecord
        ]
    )),

 Can that be changed to be a CDS type source.   I really have no clue what the difference is between CDS and OData !!!!

v-aatheeque's avatar
v-aatheeque
Community Support
4 months ago

Hi mike_asplin 

This issue is often related to credential mismatches or stale OData connections. You can try the following steps to resolve it:

1.Clear permissions in Desktop

  • In Power BI Desktop → File → Options and settings → Data source settings.
  • Clear all stored permissions for CDS, SharePoint, and web sources.
  • Re‑authenticate each source with the correct account.

2. Re‑enter credentials in Service

  • Go to Power BI Service → Settings → Datasets → Data source credentials.
  • For each source (CDS, SharePoint, Excel, public web), re‑sign in using OAuth.
  • Ensure you’re using Organizational account for CDS/SharePoint, not “Anonymous” or “Windows.”

3. Check gateway configuration

  • If any source is on‑premises (Excel on local SharePoint or file server), configure an On‑Premises Data Gateway.
  • Cloud sources should not require a gateway, but mismatched settings can trigger OAuth errors.

4.Verify resource URLs

5. Republish the report

  • After resetting credentials, republish from Desktop to Service.
  • This often clears stale OData references that the Service still holds.

Hope this helps !!
Thank You.