If you have read the Foundation books, the series will piss you off. Not just because it has very little in common with the books but because it goes against what the books stood for. And the most interesting parts of the Foundation tv series are the emperor arcs, which are original and arent from the books.
It seems to me that the creator wanted to make a scifi series of his own but just used the Foundation name for branding, name dropping and some abstract story elements. And then try to marry all the elements with some inane movie alchemy bullshit.