Forum Discussion
error when processing the data in the dataset.
I have two data sources: an excel file and a connection to sql server.
The power bi report refreshes fine but when I upload it to the server and schedules the refresh I constantly get the same error message. I thought this might be because i had the file in a shared network drive so then i moved it to my desktop. The same error message appears... I know there is no issue with the excel file since everything works fine on the desktop :
- i have the lastest powebi desktop version, the lastest personal gateway version and ive also download the pbix file from the service and there was no issue in the downloaded file
There was an error when processing the data in the dataset.Hide details
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Information is needed in order to combine data"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SQL\",\"path\":\"server_name;db_name\"},{\"kind\":\"File\",\"path\":\"C:\\\\Users\\\\name\\\\Desktop\\\\ExcelFileName.xlsx\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: Fact Table.
I fixed the issue by setting both privacy settings for the SQL and Excel Workbook connections to Public.
9 Replies
Hi RogerSteinberg ,
Do you check the privacy level in data source settings of gateway? If it is privacy, please try to change it to None or Public.
Yep it was already on None
Hi RogerSteinberg ,
Well, maybe you could try to create a support ticket to get the dedicated support.
Hi,
Your resolution is correct and I resolved my problem through resolution.
Hmm. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".Hi Im also getting this issue and Im a little confused. what If you dont want to set this to public?
I want to set it to organisational because that seems like the best fit. What is the actual problem? Im using Excel Files in Sharepoint as the file source
Private Data sources set to Private contain sensitive or confidential information. Visibility can be restricted to authorized users. Data from a private data source won't fold in to other data sources, including other private data sources. Facebook data, a text file containing stock awards, or a workbook containing employee review information. Organizational Data sources set to Organizational can fold in to private and other organizational data sources. They can't fold in to public data sources. Visibility is set to a trusted group. A Microsoft Word document on an intranet SharePoint site with permissions enabled for a trusted group. Public Files, internet data sources, and workbook data can be set to Public. Data can fold in to other data sources. Visibility is available to everyone. Free data from the Azure Marketplace, data from a Wikipedia page, or a local file containing data copied from a public web page.
