Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Sharepoint api version differences

Hi, Pls help the differences with/without api version fetching data to query since I keep getting error:  OLE DB or ODBC error: [DataSource.Error] An error happened while reading data from the prov...
  • Akash_Varuna's avatar
    1 year ago

    Hi Anonymous The ApiVersion=15 is for SharePoint 2013 or later (modern SharePoint Online), while ApiVersion=14 is for SharePoint 2010. If you don’t specify an ApiVersion, Power BI auto-selects one, which might cause compatibility errors. To resolve the issue, explicitly use ApiVersion=15 for SharePoint Online. Ensure there are no network disruptions or configuration mismatches in your connection.