Forum Discussion
Creating a data profiling table: 'We cannot convert a value of type Function to type Table..'
Hello I am trying to use power query to create a table that contains profiling data that is returned by Table.Profile() for all tables. The idea is to have one table that contains table/column re...
Hi Anonymous ,
Based on my research, it semms like you lack the relevant credentials of the data source in Power BI Desktop.
Also, this happens if you have mixed data types in your column to expand.
Similar post: Expression.Error: We cannot convert a value of type Record to type Function.
Cannot convert value to type table
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.