Forum Discussion
Issue with Filter by List by Devscope Visual
I found a solution that is currently working for me (I'm on PBIRS January 2023 version). This youtube video got me pointed in the right direction:
https://www.youtube.com/watch?v=mqDDgPDhSE4
If you have a PBIX file with a previously working version of the FilterByList visual, you can
- export a template of your dashboard (PBIT).
- Then you open the PBIT template file in 7zip or Winzip and find the 'FilterByList507A2DBEC31244C8AAABDE9BA541F723' folder within Reports>Custom Visuals.
- Extract the files within and repackage/zip them up as a new file ending in pbiviz (e.g. CustomVisual.pbiviz)
- Back in your PBIX file, in the Visualizations pane, select ... and then 'Import a visual from a file'
- Select your newly packaged pbiviz file and you should get a messaage 'Import successful'
Between steps 3 and 4, I did something that I'm not sure is necessary. I read in this thread about the need to modify all references of a 'guid' variable throughout the files in the FilterByList folder. I might've done overkill on this, but I'll try to explain.
- The folder inside the PBIT file was named 'FilterByList507A2DBEC31244C8AAABDE9BA541F723' so I appended that name with 'XX' to become 'FilterByList507A2DBEC31244C8AAABDE9BA541F723XX.'
- Within the folder is a file 'package.json' - it contained a 'guid' variable and also another reference to FilterByList507A2DBEC31244C8AAABDE9BA541F723. In both cases I appended the values with 'XX'
- Within the folder there is another folder 'resources' and a json file called 'FilterByList507A2DBEC31244C8AAABDE9BA541F723' I appended the 'XX' to that filename as well.
- I opened that file and did a find/replace on all references to '507A2DBEC31244C8AAABDE9BA541F723' in order to append them with 'XX' - there were probably 5-10 of them.
- I saved all those changes to the files before extracting/zipping them.
Anyway, good luck and you can PM me if you need any help.
I found a solution that is currently working for me (I'm on PBIRS January 2023 version). This youtube video got me pointed in the right direction:
https://www.youtube.com/watch?v=mqDDgPDhSE4
If you have a PBIX file with a previously working version of the FilterByList visual, you can
- export a template of your dashboard (PBIT).
- Then you open the PBIT template file in 7zip or Winzip and find the 'FilterByList507A2DBEC31244C8AAABDE9BA541F723' folder within Reports>Custom Visuals.
- Extract the files within and repackage/zip them up as a new file ending in pbiviz (e.g. CustomVisual.pbiviz)
- Back in your PBIX file, in the Visualizations pane, select ... and then 'Import a visual from a file'
- Select your newly packaged pbiviz file and you should get a messaage 'Import successful'
Between steps 3 and 4, I did something that I'm not sure is necessary. I read in this thread about the need to modify all references of a 'guid' variable throughout the files in the FilterByList folder. I might've done overkill on this, but I'll try to explain.
- The folder inside the PBIT file was named 'FilterByList507A2DBEC31244C8AAABDE9BA541F723' so I appended that name with 'XX' to become 'FilterByList507A2DBEC31244C8AAABDE9BA541F723XX.'
- Within the folder is a file 'package.json' - it contained a 'guid' variable and also another reference to FilterByList507A2DBEC31244C8AAABDE9BA541F723. In both cases I appended the values with 'XX'
- Within the folder there is another folder 'resources' and a json file called 'FilterByList507A2DBEC31244C8AAABDE9BA541F723' I appended the 'XX' to that filename as well.
- I opened that file and did a find/replace on all references to '507A2DBEC31244C8AAABDE9BA541F723' in order to append them with 'XX' - there were probably 5-10 of them.
- I saved all those changes to the files before extracting/zipping them.
Anyway, good luck and you can PM me if you need any help.
see below.... (and copied here).. developer provided a standalone version of the slicer you can download from them
We will give you access to the old version so that you can use it internally in your reports. The only difference is the Internal Id so Power BI online does not automatically update to the newest version.
Please download it here - https://download.devscope.net/setups/FilterByList/FilterByListOnPrem.2.1.0.0.pbivizWe are trying to roll back licensing, but we are dependent on Microsoft's validation process.
So while the validation process takes place, anyone on the forum can use the link.Thanks alot , this solved the issue for now with publish reports with Jan-2024 version eport server
It is working in Power BI Desktop, but the moment I am publishing it to services, new version is automatically updated.
I think the extra steps I mentioned about modification of the 'guid' variable is supposed to prevent it from updating. I am on PBIRS and not the full PBI cloud service, so I can't vouch for this solution in your setup.
this worked still after you published it to the Report Server? Thats where I was having issues previously.
Tried the above steps, got error "File FilterByList....pbiviz isnt a valid custom visual. Will try again
I PM'd you
Thanks! This solution worked for me.
The actions between steps 3 and 4 are crucial. It won't work without that.
Thanks. I tried it twice now and am getting the same error as NorwaySasquatch - invalid custom visual. . So frustrating that this isn't fixed yet. I have users that need to paste and sync hundreds of values across a report. Thanks again for any help.
