Forum Discussion
Helper IData Refresh Error - SharePoint Excel Sheet Appended to On-Prem dataset through Data Gateway
Hey there!
Thank you for your response.
I did check the privacy levels and they do seem to be set at the appropriate level for both sharepoint and my on-prem data source.
The only thing that I did not try is to "Add Sharepoint to the gateway", I do not have admin access to do this. This could potentially make it work, I do not know.
However, I have made use of "DataFlow" to connect to sharepoint and then use that for append/merge operations. This seems to be working fine since it bypasses the gateway.
Thanks
Community SupportHi Gladiator909 ,
This may be an error caused by not setting the appropriate privacy level for the cloud data source.
On the dataset settings page, expand Data Source credentials, and then click on Edit credentials for the data source you want to configure, and then select the desired privacy level under Privacy level setting for this data source. If the specific steps are not clear, please refer to the following link:
Privacy Levels for Cloud Data Sources | Microsoft Power BI Blog | Microsoft Power BI
Solved: Re: DM_GWPipeline_Gateway_MashupDataAccessError - Microsoft Power BI Community
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IHey there!
Thank you for your response.
I did check the privacy levels and they do seem to be set at the appropriate level for both sharepoint and my on-prem data source.
The only thing that I did not try is to "Add Sharepoint to the gateway", I do not have admin access to do this. This could potentially make it work, I do not know.
However, I have made use of "DataFlow" to connect to sharepoint and then use that for append/merge operations. This seems to be working fine since it bypasses the gateway.
Thanks