Data source error

[preethi07]

Information is needed in order to combine data. Please specify a privacy level for each data source.;Information about a data source is required.. The exception was raised by the IDbCommand interface. Table: Zoom API.

Hi All, Im using server to server connection to get data from zoom api. i have 2 url's. one to get the api key and the other one to get the data. evrything is working fine in the power bi dekstop. but im getting issue in the power bi service when im trying to set up automatic refresh. I tried all the methods. I set the privacy levels as "Always ignore Privacy Level Settings" in the options and settings and in the power bi desktop and service i set the permissions as Type:Anonymous and Privacy Level: None. But nothing seems to be working. In the same powerbi report i am getting another data from sharepoint and i appended both queries. To get the data from sharepoint i had to  sign in to my organization account but i set the privacy level: None. I thought that might be the issue and removed the appended queries step. Now both the queries are not appended but I am getting data from sharepoint and zoom API seperately. But im still getting the same error.

For the reference see the picture attached.

 

Hope somebody has the answer for this problem.

Thank You so much inadvance.

[ibarrau · Accepted solution]

First, the privacy level is how you treat a source, you can flag the zoom api as organizational privacy level. It doesn't relate to you organization it's a flag of how it can be related to the other sources. Second, I thought that was the idea, because you have started with "Information is needed in order to combine data. Please specify a privacy level for each data source.;Information about a data source is required.. The exception was raised by the IDbCommand interface. Table: Zoom API." You change it because of the failure, but it looked like you wanted to do it.

I'm sorry about the confusion, let's see. If you don't want to combine/append/merge, then the picture shows a credential issue at zoom api. Make sure sharepoint credentials are not showing errors. Regarding zoom, in order to use anonymous, it means you are solving auth by code. Means that you are not specifying by UI a login but everything by body/header/etc.

Can you share details in power query code (you can hide the keys/passwords with XXXXXX) in order to help us understand how you are login? we can check if there is something odd at that code.

Please unmark the skip test connection, that one validates the connection.

Regards,

[Akash_Varuna]

Hi @preethi07 It might be due to privacy level conflicts when combining data could you check for these 

• In Power BI Service, go to Settings > Datasets > Data source credentials:

  • Set Zoom API to Anonymous with Privacy Level: None.

  • Set SharePoint to Organizational Account with Privacy Level: None.

• If combining queries, ensure privacy levels for all sources are set to "None" to avoid conflicts.

[preethi07]

Hi @Akash_Varuna  Thank You for your reply.

I checked all of that and all the privacy levels are set to None. I thought im getting that error becuase i combined the queries and i removed that step. so the queries are not combined now. This didnt resolve my issue.

[ibarrau]

Hi. I don't think Service let you ignore this. I usually recommend all in organizational if you are looking for combine data. It's secure and let you combine. Change all sources in the dataset to organizational. If this keeps failing you might need to change how you are combining. If you are combining inside of the same query you are cleaning, let's keep al sources and tables separate and create the combination in a third separate query. You can hide the tables used for combination and keep the combined at desktop for later work.

I hope that helps,

[preethi07]

Hi, I am not combining the data now. The data is there in two seperate tables. And i kept the share point data as organizational but i cant keep the API as organizational. Im getting the data directly from zoom.

This wont resolve my problem.

[ibarrau · Accepted solution]

First, the privacy level is how you treat a source, you can flag the zoom api as organizational privacy level. It doesn't relate to you organization it's a flag of how it can be related to the other sources. Second, I thought that was the idea, because you have started with "Information is needed in order to combine data. Please specify a privacy level for each data source.;Information about a data source is required.. The exception was raised by the IDbCommand interface. Table: Zoom API." You change it because of the failure, but it looked like you wanted to do it.

I'm sorry about the confusion, let's see. If you don't want to combine/append/merge, then the picture shows a credential issue at zoom api. Make sure sharepoint credentials are not showing errors. Regarding zoom, in order to use anonymous, it means you are solving auth by code. Means that you are not specifying by UI a login but everything by body/header/etc.

Can you share details in power query code (you can hide the keys/passwords with XXXXXX) in order to help us understand how you are login? we can check if there is something odd at that code.

Please unmark the skip test connection, that one validates the connection.

Regards,

[preethi07 · Accepted solution]

Hi,

Thank you so much, It worked for me after flagging the privacy level as organizational. I was flagging it as None before. I still have to Mark the Skip test connection though. 

But now, I am getting the data into two different tables. I didnt combine them. I can work with that.