fbcideas_migusr
9 years agoNew Member
Status:
Needs Votes
Refresh from access restricted Excel workbook
In addition to password protecting workbooks, Excel also supports restricting access based on users (ACL). It's a common practice to ACL workbooks in Excel to limit access to confidential data, that is used as a data source for PBI reports/dashboards. Today Power BI fails to refresh from access restricted Excel workbook, and one has to save a copy, stripped of access restrictions, use that to refresh Power BI report, and then manually republish. Auto-refresh doesn't work, essentially making operationalization of PowerBI reports based on Excel workbooks containing confidential data impossible, even if the report doesn't pull confidential data itself from the workbook.
2 Comments
- alex_rubanenkoNew MemberI agree totally, I have the same situation and it is shame I can't connect to restricted excel files. Although I am using Power Query in excel, but I am sure it is the same for Power BI
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Allow us to rename fabric data agents published to m365
If we use deployment pipelines to promote fabric data agents between dev, test/UAT, and prod fabric workspaces, we need to keep the name of the fabric agent the same in each workspace. If we want to ...PeterDaniels2 hours agoAdvocate IIINew177Views0likes2CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen3 hours agoAdvocate INew292Views47likes2CommentsSupport Encrypted Sensitivity-Labeled Excel Files in Power Query
Description Currently, Power Query Online and Power Query in Excel are unable to access encrypted Excel files. Excel files with sensitivity types other than Public or Non-Business can be encrypted a...ewarstdhyjugkhi3 hours agoMicrosoft EmployeeNew17Views6likes0Comments