Filter data with a list

Question

Hi ,&nbsp;I created a list based on excel sheet from sharepoint.With the list I filter my sql query using (ex. Select * from Accounts where AccountID IN(ListFromExcel))&nbsp;It’s working fine in my PB desktop and i can refresh the data and get what i'm expecting to get.&nbsp;When I published my pbix to server and try to Refresh the data source I get error :&nbsp;Underlying error code:&nbsp;-2147467259Underlying error message:&nbsp;[Unable to combine data] Section1/Accounts/Source references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.DM_ErrorDetailNameCode_UnderlyingHResult:&nbsp;-2147467259Microsoft.Data.Mashup.MashupSecurityException.DataSources:&nbsp;[{"kind":"SQL","path":"SERVER;DATABASE"}]Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacyErrorCluster URI:&nbsp;WABI-WEST-US-redirect.analysis.windows.net&nbsp;Do you know how to solve this issue ?

vanessafvg · Answer

have you checked your privacy settings?https://docs.microsoft.com/en-us/power-bi/admin/desktop-privacy-levels

anonymous · Answer

Hi&nbsp;RsimonAlign,
As&nbsp;vanessafvg&nbsp;said, it may be related to data privacy setting issues when your query table reference data across different query tables on power bi service. You can double-check on the data privacy setting on power bi service side.
Power BI Security#data-storage-security&nbsp;
BTW, what happens if you directly add get data external data in your query table?
Regards,
Xiaoxin Sheng

Forum Discussion

Filter data with a list

2 Replies

Related content

Filtering Data

Filter data using slicer

Bookmarks Filter Data

Data Filter Scenario

Filtering Data challenge