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: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Eleftheria_K

Power BI Desktop Optimised for RS (Jan 2022) - Native Query problem

Submitted by on ‎03-10-2022 01:02 PM

Hello!

I am facing an issue and even though I tried hard to solve it I didn't make it. I have written a native sql query which has an aggregation function (max) and some where clauses in it and even though when I run it to management studio works fine and brings only one value for each ID which is the correct, in Power BI brings for some IDs double values (neither the aggregation and group by works not the where clause). Have anyone faced anything like that?

 

Thank you in advance

Eleftheria

Status: Needs Info
See more ideas labeled with:
6 Comments (6 New)
Comments
Anonymous
Not applicable
‎03-10-2022 06:53 PM

Hi @username 

Maybe you can provide your sql query and data on Power BI ?

 

Best Regards,
Community Support Team _ Ailsa Tao

Eleftheria_K
Frequent Visitor
‎03-10-2022 09:42 PM

Hi @Alisa-msft unfortunetely I cant because they are sensitive data.

 

RizzeTopacio
Regular Visitor
‎05-20-2022 06:44 AM

I have the same issue on this. 

Created a new parameter coming from a Sharepoing list, add as a 'New Query' on one item. Combine it in a Native Query.

Sample SQL: 
select * from sys_user_groups where name in ("&List.First(Parameter_EUS)&")

On the Power BI Desktop Jan 2022 its working but when published i got this error message: 
[0] -1055784932: [Unable to combine data] Section1

Tried this fix, but no luck passing through the error every refresh: 
- Changing Privacy Levels to 'Always ignore Privacy Level settings'


Hoping for some advice here. Thank you in advance. 

Eleftheria_K
Frequent Visitor
‎05-23-2022 12:22 AM

Hello,

 

About the "Always ignore Privacy Level settings" have you tried to disable the "Require user approval for new native database queries" in options & Settings --> Security?

RizzeTopacio
Regular Visitor
‎05-23-2022 07:31 AM

Hi @Eleftheria_K :

Tried your suggestion but sadly the issue still exist. 

Is there any other approach on doing Dynamic parameters with Power M Query and Native SQL  for Power BI that you can suggest? 

Regards,

Cha

Idea Statuses