Forum Discussion
Solved
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...
I fixed the issue by setting both privacy settings for the SQL and Excel Workbook connections to Public.
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. |