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
Super User

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
Super User

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

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors