Forum Discussion
Data source error
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,
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.
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.
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.
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,
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.
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,