Power BI integration via web API to Fresh Service

[FVal]

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 the connection, due to an error related to the field "ID" that got an extra space in front of the name, becoming " ID".

This issue was resolved at this moment, but all our existing reports are still seing it with the wrong value. If we manually edit a report, the reports still does not work.

If I press the "Fix this" button, the report vanishes completly.

We tried clearing the permission, changing the source but still the same issue and it continues to show the old wrong " ID" instead of the corrected "ID" as the source have it now fixed.

Is there a way in Power BI to clear the cache or something similar?

Thank you,

V.

[amitchandak]

@FVal , In data transformation mode. Right click on the table and open advance editor and correct the name coming from the source.

Save that and rename the column in power query or in Data view to be the same as the old one. All visuals will work

[FVal]

Hi,

Still getting the error, below is the exact message:

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.

• Data source error{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"The column 'ID' of the table wasn't found."}}],"exceptionCulprit":1}}} Table: All_tickets_from_Fresh_API_Analytics.
• Cluster URIWABI-WEST-EUROPE-redirect.analysis.windows.net
• Activity ID47180205-8938-4322-8521-1cac42d27209
• Request ID151cff66-e753-70c1-e4c4-043170ea636e
• Time2020-09-10 13:27:15Z

[Anonymous]

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"