Solved: Trying to make additional column from source table

jaryszek · ‎06-30-2022

Hi,

i am adding additional column with data source, like if SourceKind = "Web" then Csv.Document(Web.Contents([Connector]),[Delimiter=",", Encoding=1250, QuoteStyle=QuoteStyle.None]) else [Connector])

And it is working for Web files.
But i have also Connector =

=PostgreSQL.Database("127.0.0.1:9998", "junit")

and from this power query seeing this as text not as source.

How to make from this string source table in additional column?

Please help,

Best,
Jacek

CNENFRNL · ‎06-30-2022

= if SourceKind = "Web" then Csv.Document(Web.Contents([Connector]),[Delimiter=",", Encoding=1250, QuoteStyle=QuoteStyle.None]) else Expression.Evaluate(Text.RemoveRange([Connector],0), [PostgreSQL.Database = PostgreSQL.Database])

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

jaryszek · ‎06-30-2022

Thank you, interesting.

Jacek

CNENFRNL · ‎06-30-2022

= if SourceKind = "Web" then Csv.Document(Web.Contents([Connector]),[Delimiter=",", Encoding=1250, QuoteStyle=QuoteStyle.None]) else Expression.Evaluate(Text.RemoveRange([Connector],0), [PostgreSQL.Database = PostgreSQL.Database])

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!