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, 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,
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.