Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Reading encrypted workbooks error from auto refresh

Hi,   I continiously getting this error from auto refresh.  It is working if I open .pbix and manually refresh and pulish.          let Source = SharePoint.Contents("https://nokia.shar...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-prasare's avatar
    v-prasare
    1 year ago

     Anonymous, Thanks for reaching out Fabric Community Support.

    Tahreem24, Thanks for promt response.

     

    Anonymous, According to the error message, this is due to your current Workbooks being encrypted thus  preventing from auto-refreshing. When connecting to workbooks using Power BI Desktop, credentials and permissions have been established in PBI Desktop, but these may not transfer during the auto refresh process, resulting in the error. If you want to enable automatic refresh using Power Automate, the only current way is to remove the encryption.

    Best Regards,
    Prashanth Are
    Community Support Team

     

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

v-prasare's avatar
v-prasare
Community Support
1 year ago

 Anonymous, Thanks for reaching out Fabric Community Support.

Tahreem24, Thanks for promt response.

 

Anonymous, According to the error message, this is due to your current Workbooks being encrypted thus  preventing from auto-refreshing. When connecting to workbooks using Power BI Desktop, credentials and permissions have been established in PBI Desktop, but these may not transfer during the auto refresh process, resulting in the error. If you want to enable automatic refresh using Power Automate, the only current way is to remove the encryption.

Best Regards,
Prashanth Are
Community Support Team

 

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks, actually it is not about power autumate, just using scheduled refresh over PBI, 

still does it matter? 

  • v-prasare's avatar
    v-prasare
    Community Support
    1 year ago

    Hi Anonymous, my apologies power automate was typo mistake here. power automate does not matter here.

     

     

     Thanks,

    Prashanth Are

    • v-prasare's avatar
      v-prasare
      Community Support
      1 year ago

      Hi @jeongkim, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you  or let us know if you need any further assistance?

       

      Your feedback is important to us, Looking forward to your response. 

       

       Thanks,

      Prashanth Are