Hi @det103
Based on your description, your issue seems to be more related to development of Excel and Power BI. I will add tags related to Office development.
To better help you, it's also recommended to post this issue on Microsoft Power BI Community.
Thanks for your understanding.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.