Forum Discussion
Anonymous
4 years agoNot applicable
Run multiple queries during drilldown and use selected elements from visual in SQL-where clause
We are trying to use Power BI Desktop / Power BI report server to display results from a big data warehouse realized in postgres. I am working on views to be used with Power BI, either with <DIRECT ...
Anonymous
4 years agoNot applicable
I came a bit closer to my goal creating an m-query for our postgres database using parameter, but the Postgres.Database function complains about a string, if it was produced with Text.Combine. What am I doing wrong here or is there a problem?
see details :
This m-query ,which has no syntax erros, gives the following error, it looks like the postgres DB does not like the string made of substrings and parameter :
But if I use a string which was not a result of text.Combine then it works, the following works.
But I need Text.Combine to get my parameter in.
What am I doing wrong here ?
If some of you gurus sees my mistake, please give me a hint.
Many thanks in advance.
lbendlin
4 years agoSuper User
Text.From([P_ISO_Week_Of_Year])