Forum Discussion
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.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"
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 TeamIf 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
5 Replies
Anonymous ,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:
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 TeamIf 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
Hi Anonymous, my apologies power automate was typo mistake here. power automate does not matter here.
Thanks,
Prashanth Are
