cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gdps
Helper IV
Helper IV

Problem to update Data Set

Hello all,

 

I have a report where I use 2 databases:
1) A list from Sharepoint
2) An Excel file from my computer

 

I'm trying to update the dataset via app.powerbi.com, but I'm encountering the following error:

 

 

Any idea on how to solve this?

 

Another question, is there any good practice regarding this excel file on the computer? I use it to create support tables (eg, group categories from the main database). I don't know if it's better to keep it on my computer, or put it in the cloud (or something). What is better to do?

 

Best Regards

1 ACCEPTED SOLUTION
GilbertQ
Super User II
Super User II

Hi there

Go into manage gateways in the Power BI Service.

On each of the data sources what happens if you change the Privacy settings to "Organizational"

And then try and refresh the data?

Also make sure your Privacy settings in Power BI Desktop is set to ignore.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
v-lid-msft
Community Support
Community Support

Hi @Gdps ,

 

First of all, we suggest you to delete the Share Point URL and excel location information in your screenshot. 

 

If you do not want to configure the gateway for this local excel file or the computer can not run all the time when the dataset refresh, put it into a safe cloud place (such as SharePoint or OneDrive for Business) will be a better choice.

 

Please also refer to this document How the privacy defined on data source affect the merge/append for different tables as Gilbertq has said : https://docs.microsoft.com/en-us/power-bi/desktop-privacy-levels


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GilbertQ
Super User II
Super User II

Hi there

Go into manage gateways in the Power BI Service.

On each of the data sources what happens if you change the Privacy settings to "Organizational"

And then try and refresh the data?

Also make sure your Privacy settings in Power BI Desktop is set to ignore.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!