reporting services - When executing report part in Report Builder, The path of the item "~" is not valid. The full path must be less than 260 characters long -
all, recently ran issue while working on report parts client. have utility creates report parts in batches based on information provide it. includes paths datasets , data sources. after creating report parts , corresponding data sources (all tablixes based on views) tried run them in report builder 3.0. got error: the path of item '{path report part here}' not valid. full path must less 260 characters long at first assumed path length issue, since long path. around 160 characters. not close. when expand error message, essential, this: ...; other restrictions apply. if report server in native mode, path must start slash. this ended being issue. person ran utility incorrectly eliminated leading forward slash in path data sets , data sources. along these lines on msdn, wanted have here well. my suggestion open xml files in notepad ++ , replace paths across files have. you'll have both report parts , data sources far know.