Forum Discussion
An unexpected error occurred (file '', line , function '')
Hi,
After installing on several devices and noticing that some returned errors while others didn’t, I compared the system information of each one and found that the issue, in this case, is related to AVX CPU extension support. One of the VMs didn’t inherit this extension from the host, and once it was enabled, the error disappeared.
We can conclude that the error is related to CPUs lacking the AVX extension.
Best Regards.
Can you tell me more about your macro/script idea?
Hey lstanczyk1 ,
If you are dealing with several reports that have slicer-related issues, automating the slicer recreation can save you significant time. To automate recreating date slicers across multiple reports using macro/script, you can use the following methods:
PowerShell Script: Automate the process of identifying, removing, and recreating date slicers in multiple PBIX files, then republish the updated reports.
Power BI REST API: Write a custom script to interact with Power BI reports, replacing the date slicers programmatically and automating the update process.
Template Approach: Create a reusable Power BI template with the correct slicer configuration, then copy visuals into other reports.
Third-Party Tools: Use tools that can batch-edit PBIX files, allowing for easier slicer management across multiple reports.
For Detailed Information:
PowerShell Scripting for Power BI
Power BI REST API Documentation
Automate Power BI Service with Power Automate
If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Best Regards,
Nasif Azam