cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bart12345
New Member

direct query error without doing transformations

When I use direct query functionality to retrieve data from a database (without doing any transformations) I get the following error message:

'this query contains transformations that can't be used for directquery.'

 

Any ideas why this message appears?

 

thanks!

 

regards Bart

 

 

3 REPLIES 3
bart12345
New Member

Hi Ehren, sure. the sql is nothing special. just a count and a group by

 

select x, count(a1.pkey)

from x1 a1
Join x2 a3 on
where x in ('xx','xxx') 
group by x

Hi there. Can you share the full M formula text of your PQ queries (not just the SQL)?

Ehren
Microsoft
Microsoft

Can you share the M formula text of the query where you're seeing this error?

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

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

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!