OLE DB or ODBC error by getting data about ccoinsights

[josunefon]

Hi @adminph-de,

Did you setup power bi to ignore privacy levels between datasets? Did you followed all the steps listed here? https://github.com/Azure/ccodashboard/blob/master/install/DeploymentGuide.md#setting-up-the-continuous-optimization-power-bi-dashboard

Only one error is expected on the first run if all the configuration is properly set because Power BI is not asking for the graph API authentication and is simply fixed by refreshing the dashboard after the first run…

[adminph-de]

Hi josunefon,

I tried to refresh, same issue, ODBC error. After I did a cleanup in the Datasource Credentials before I refresh, the following "error" shows up every time

and the PowerBI crashes.

[josunefon]

Can you check the privacy level?

[adminph-de]

Checked.....

[josunefon]

Can you check the URL? just to see which resource provider fails

[adminph-de]

https://graph.windows.net/myorganization/servicePrincipals

I didn't change the settings here. I only add my credentials.

[josunefon]

Are you using an outlook or a hotmail account? because graph API doesn't work with this type of accounts

[adminph-de]

I'm using my Azure AD account. We also tried an account without MFA protection, same result. Is. there anything In regards of Azure "restrictions" we need to check or change?

[josunefon]

There're no restrictions and MFA is not a problem.

There's any way to contact you directly and make a remote session to see directly what's happening?

[adminph-de]

Sorry for my delay, I was out of office for a few days.

Yes, this would be nice, if you have the time I would like to do a remote session.
How should we organize?

[josunefon]

Send an email to [email protected] and confirm me your availability :)

[josunefon]

@adminph-de I have an idea about what is happening, it's something related with the error control in Power BI, you have to enter to edit queries and check after every API Call the results. If you have errors and you don't have a step named remove errors at the applied steps section, the load of all data will fail.

I'll review all the API calls to insert the error control step to avoid this problems. And to clarify we're not losing data, we don't have access to request the data with our access level :)