Enable different authentication methods to xConnect OData

Recently, we had a client that wanted to extract data from xConnect using Power BI. One option available was through the built-in OData service – https://site-prefix.xconnect/odata endpoint. The challenge was that Power BI (among other tools) doesn’t support the kind of authentication that xConnect implements.

Continue reading “Enable different authentication methods to xConnect OData”

XConnect IndexWorker error “Tokens are incompatible, they have different set of shards.”

Recently, I had restored a “production” backup of the master and core databases from a Sitecore 9.0 Update-1 instance to my local SQL server installation. After that, the Sitecore log started filling up with the exception:

Sitecore.XConnect.XdbSearchUnavailableException Message: The HTTP response was not successful: InternalServerError.

Continue reading “XConnect IndexWorker error “Tokens are incompatible, they have different set of shards.””