Forum Discussion

FVal's avatar
FVal
Helper I
6 years ago

Power BI integration via web API to Fresh Service

Hi,   We use Power BI to run reports from a ServiceDesk tool, Fresh Service. The integration is done via a web API link.   Recently, the Fresh Service development team updated something and broke...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi FVal 

On power query editor add a step at the end and rename this column from " ID"   to "ID".

Easiest way is to double click on the " ID" column name in editor window and remove space 

or add the below code in  your advance editor. Basicaly #"Renamed Columns" step is waht you need from below M query.

let
    Source = <Something... Something..>,
    #"Changed Type" = Table.TransformColumnTypes(Source,{{" ID", Type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{" ID", "ID"}})
in
    #"Renamed Columns"