Forum Discussion
Custom API call added as column
Hi guys Hope you can help me out. I have got a column with a logger ID for each row. Then added a custom column with API web to retrieve data for each loggerid. Then I simply added another column...
mariopavic Yes, the custom column exists as below. The custom column contains the API web address as https://energycloud.com/api/LoggerData/dailytotals?&channelNumber=1&apiKey=cb&pageSize=100&orderby=id&page
The equal symbol equals to page number
[Custom]&"="&Text.From([Page])Try this
mariopavic thanks again. However, its coming with error 'Custom' column cannot be found.
No problem. Can you just take a screenshot of the whole table you're using?
The whole table is literally same as the first two rows with different ids. The issue is that I have created this custom column however not sure how to add this in custom1 column field as power bi does not recognise custom as a record.