API call- Cannot convert the value to Type text

[PoweredOut]

Hello

I am facing some issues calling an API within a Dataflow. It works perfectly in Desktop. I have done some research, but I can't seem to implement the suggestions. One of the suggestions seems to have worked, but I get the Expression error "We cannot convert the value to type text" I know that there is a logical type column in the data I'm trying to call. Could this be the reason, if so, how can i change this?

This is the Mquery within Power BI Desktop and it refreshes perfectly in the Service

let
     Source = Json.Document(Web.Contents("https://somekey-.execute-api.eu-west-1.amazonaws.com/sometable?hapikey=somekey"), 65001)
in
source

 This is the Dataflow MQuery

let
     Source = Json.Document(Web.Contents("https://somekey-api.eu-west-1.amazonaws.com/" ,[Headers=[Authorization="hapikey"="somekey"], RelativePath = "/sometable"]), 65001)
in
    Source

Thanks

[v-luwang-msft]

Hi @PoweredOut ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi  @PoweredOut ,

Pls check if the table with the Blank rows,diete the blank rows first.

Similar refer:

https://community.powerbi.com/t5/Desktop/Expression-Error-We-cannot-convert-the-value-to-type-Text/t... 

Best Regards

Lucien