Forum Discussion
Resolver IVDataflow and Rest API - We cannot convert a value of type Table to type Text
Did you maybe forget to specify the GroupID ?
You were probably right about the missing Group Id 😑 I changed a few things since my last attempt including the API permissions. I had initally enabled Group.Read instead of Group.ReadAll accidatally, so it probably was either not returning anything when calling those group ids or not getting the ids just during validation...but did get all the ids for my Group table on refresh 😕
I still don't understand why it was still pulling all the groups in the dataflow and everything else was working correctly in Postman and Power BI Desktop though. The scope and authentication are the same in the token request, so you would think the issue would arise sooner but for some reason it was only on dataflow validation for objects within groups that that it occured.
Ran it twice though and is seems to be working. Thanks for the help!
Super User"I've tried going into the Project options and Global options and turning off Auto detect column types, but for whatever reason it just turns back on next time I open the project."
I have seen similar issues where dataflow insists on adding column type conversion steps although I explicitly asked it not to do that. I think that is either a very bad design decision (given that dataflows at the end of the day are just glorified CSV files) or a bug. Might be worth raising as an issue.