Forum Discussion

FVal's avatar
FVal
Icon for Helper I rankHelper 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...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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's avatar
    FVal
    Icon for Helper I rankHelper I
    6 years ago

    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