Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

0
brendan_w_FWM

Appended Table fails to refresh in Service

Submitted by on ‎11-02-2023 01:33 AM

Hi, 

 

The issue I'm encountering is that an appended table that combines two datasources fails to refresh in the Power BI Service with the following error:

 

<ccon>Information is needed in order to combine data. Please specify a privacy level for each data source.</ccon>;<

 

However the privacy level is specified for both data sources and it refreshes succesfully in the desktop app.

 

Can you advise on how to fix?

 

Many thanks,

Brendan 

Status: Delivered
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎11-02-2023 06:59 PM

Hi  @brendan_w_FWM 

According to your error message, I checked the relevant problem documents, and the reason is due to the privacy level of the data source configuration.

You can follow my steps below to troubleshoot if the issue is caused by inconsistent "Privacy setting" settings:

(1) You can open the corresponding PBI desktop local file first, and go to the option "Option and Settings-Options" to open this option:

vyetao1msft_0-1698976670404.png

(2) Then you go to "Data Source Settings" and make sure that the "Privacy setting" settings of all data sources connected to your dataset are consistent:

vyetao1msft_1-1698976707423.png

(3) After confirming the consistency, you can perform a desktop data refresh to ensure success.

(4) After the refresh is successful, you can republish to and try to reconfigure the data source definition for the data source of the related dataset to ensure that the "Privacy level" configured on the Serive is consistent with that of the Desktop:

vyetao1msft_2-1698976725712.pngvyetao1msft_3-1698976733064.png

If the above methods cannot help you troubleshoot the problem, you can provide your detailed error information so that we can better help you solve the problem.

 

Best Regards,
Community Support Team _ Ailsa Tao

brendan_w_FWM
Regular Visitor
‎11-07-2023 02:48 AM

@AilsaTao  Thanks for the prompt reply. I tried the above but it didn't work but I did discover cloud connections while performing the above. When I created a cloud connection instead of a personal cloud connection; the refresh works.  Thanks for all your help 🙂

Anonymous
Not applicable
‎11-07-2023 05:06 PM

Hi  @brendan_w_FWM 

I am so glad to hear that your have fixed your issue . I will change the status to "Delivered"  .

 

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses