ITLec / PowerQueryBuilder

13 stars 5 forks source link

While using FetchXml Query and Power BI the link feature is producing an error #38

Open KFAllegion opened 4 months ago

KFAllegion commented 4 months ago

While using FetchXml Query for Power BI when a URL for the record is added the results in Power BI produce an error while the remaining field display data. Here is the fetch for the URL:

"Added Link" = Table.AddColumn(#"Changed Type", "Link", each Dyn365CEBaseURL & "/main.aspx?etn=hsl_customervisit&pagetype=entityrecord&id=%7b"& [hsl_customervisitid]&"%7d"),