Reading encrypted workbooks error from auto refresh

[jeongkim]

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.sharepoint.com/sites/xxxxxxx", [ApiVersion = 15]),
#"Shared Documents" = Source{[Name="Shared Documents"]}[Content],
#"KR PO Plan" = #"Shared Documents"{[Name="KR PO Plan"]}[Content],
SKT = #"KR PO Plan"{[Name="SKT"]}[Content],
#"SK_5G Bottom up plan" = SKT{[Name="CT SK_5G Bottom up plan"]}[Content],
#"Filtered Hidden Files1" = Table.SelectRows(#"SK_5G Bottom up plan", each [Attributes]?[Hidden]? <> true),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])),
#"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
#"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(#"Transform File"(#"Sample File"))),
#"Sorted Rows" = Table.Sort(#"Expanded Table Column1",{{"Source.Name", Order.Ascending}}),
#"Removed Other Columns" = Table.SelectColumns(#"Sorted Rows",{"Source.Name", "Column24"}),
#"Renamed Columns2" = Table.RenameColumns(#"Removed Other Columns",{{"Column24", "Comment"}}),
#"Filtered Rows1" = Table.SelectRows(#"Renamed Columns2", each ([Comment] <> null and [Comment] <> " ")),
#"Added Index" = Table.AddIndexColumn(#"Filtered Rows1", "Index", 1, 1, Int64.Type)
in
#"Added Index"

[v-prasare · Accepted solution]

 @jeongkim, Thanks for reaching out Fabric Community Support.

@Tahreem24, Thanks for promt response.

@jeongkim, 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

[jeongkim]

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

still does it matter? 

[v-prasare]

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

 Thanks,

Prashanth Are

[v-prasare]

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

[Tahreem24]

@jeongkim ,By any chance do you have password protected excel file? If yes, so this might be the issue. 

You can refer the below post for your reference:

https://community.fabric.microsoft.com/t5/Service/Getting-error-quot-We-don-t-support-reading-encryp...