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

Filter data with a list

Hi ,

 

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))

 

It’s working fine in my PB desktop and i can refresh the data and get what i'm expecting to get.

 

When I published my pbix to server and try to Refresh the data source I get error :

 

Underlying error code: -2147467259

Underlying error message: [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: -2147467259

Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SQL","path":"SERVER;DATABASE"}]

Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacyError

Cluster URI: WABI-WEST-US-redirect.analysis.windows.net

 

Do you know how to solve this issue ?

2 REPLIES 2
Community Support
Community Support

Hi @RsimonAlign,

As vanessafvg 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 

BTW, what happens if you directly add get data external data in your query table?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User I
Super User I

have you checked your privacy settings?

https://docs.microsoft.com/en-us/power-bi/admin/desktop-privacy-levels




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

Proud to be a Super User!




Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors