Forum Discussion
Invalid mashup connection string
Hello After uploading new version of the model with RangeStart and RangeEnd parameters set to enable incremental loading data update in PowerBI Service fails instantly with: Something went wrong...
Yes, update was installed couple of days ago.
Just for case the query widely used in the model is:
Source = Value.NativeQuery(PostgreSQL.Database("xxxx.rds.amazonaws.com", "xxx", [CommandTimeout=#duration(0, 4, 0, 0), ConnectionTimeout=#duration(0,4,0,0)]), "select * from xx.xxx", null, [EnableFolding=true]),
#"Filtered rows" = Table.SelectRows(Source, each [created] > #datetime(2019, 6, 1, 0, 0, 0) and [created] >= RangeStart and [created] < RangeEnd),
...
This works as intended in the desktop and I can upload model into Power BI service without errors.
Also, my issue is only with a PostGres database. Just a hint that this may be part of the issue.