"Cannot convert a value of type Table to type Text" on file import

[StephenF]

I'm trying to convert a 1 x 1 table, ie a cell with a URL in it to a new file in a new query.

The Original Query is called Step1.

[v-yueyunzh-msft]

Hi , @StephenF 

According to your description, i test it in my side , it returns the same:

For this , we can not put the Table as the parameter in the "File.Contents" function  . 

The function's parameter is like this:

File.Contents(path as text, optional options as nullable record) as binary

In this case , you use the table as the 'path' parameter , so it returns the "Expression.Error: We cannot convert a value of type Table to type Text.". This error code tells us that the parameter in this function is not supported.

This function is used to returns the contents of the file, path, as binary. We can not use the 1*1 table as a parameter.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin · Accepted solution]

Remember you can address table cells by their row and column.

value = dat5555a[Column1]{0}