Forum Discussion
Simple steps not supported in Direct Query - Postgres
- 5 years ago
I just had a call with Microsoft support, we don't understand why it stopped working but we found a way to work around this query folding breaking.
I changed my M code from:
//This code was breaking the folding
let
Source = PostgreSQL.Database(Server, DataBase),
dbo = Source{[Schema="public",Item="gl_summary_union"]}[Data],
#"Renamed Columns" = Table.RenameColumns(dbo,{{"YEAR(b.GL_TRXN_CRTD_DATE)", "Year"}})
in
#"Renamed Columns"========================
To this:
//This code allows Power Bi to fold the query
let
Source = Value.NativeQuery(PostgreSQL.Database(Server, DataBase), "SELECT * FROM public.gl_summary_union", null, [EnableFolding=true]),
#"Renamed Columns" = Table.RenameColumns(Source,{{"YEAR(b.GL_TRXN_CRTD_DATE)", "Year"}})
in
#"Renamed Columns"The weird thing is that the first code worked for a couple of months!
Thanks vanessafvg for your help.
Have a great day
Alejandro
when you use direct query I am assuming power bi interpret that as your model is fully the way you want it to be.
Rather than doing a table rename in power query, why dont you use a sql statement and rename your columns in that statement?
- aramirez75 years agoFrequent Visitor
Hey vanessafvg Thanks for getting back to me..
Well, we don't want to write SQL statements - We already have a lot of reports created using M for simple transformations. It was working fine last week, Power Bi was able to create native queries for those simple transformations.
- vanessafvg5 years ago
Community Champion
have you had a software update in the last week? What has changed?
- aramirez75 years agoFrequent Visitor
Actually, I don't recall when I did the update - but yes I am using the last version (December)