Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Microsoft team,
I spent the whole day since suddenly my report stop refreshing automatically after I changed a query against postgres. Never ever faced such error earlier:
---
---
Now I understand that latest Desktop version creates a m language statement like:
= Value.NativeQuery(PostgreSQL.Database("stpgpsdev.memc.com:5433", "postgres", [CreateNavigationProperties=false]), "select * from gen_site", null, [EnableFolding=true])
while previous version was creting statement like:
= PostgreSQL.Database("scmprddb1.memc.com:5448", "scmprd", [Query="select *, #(lf)planned_gm_date-deliv_date days_delay,#(lf)doc_num||item||shipping_plant as docitemplant#(lf)from shipments#(lf)where matl_grp IN ('EPI','GR1','MMT','SOI','SUBSTRATE')", CreateNavigationProperties=false])
There is no problem running the new version from desktop but NOW REFRESH ON SERVER ALWAYS FAILS
PLEASE FIX IT!!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.