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
Variable Library: Disable default value set.
The Default Value Set in the Variable Library poses a risk. The Default Value Set will silently apply values when no explicit value set has been selected for a Test or Prod workspace. There i...frithjof_v5 hours agoCommunity ChampionNew634Views17likes2CommentsScheduled Refresh for Fabric Mirroring
Current Challenge: Fabric Mirroring runs continuously, leading to unnecessary data replication and higher Snowflake costs. There is no built-in option to schedule mirroring based on specific times o...ram_eternal1897 hours agoRegular VisitorNeeds Votes472Views3likes2CommentsMake 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...TeemuMultanen8 hours agoAdvocate INew264Views42likes1CommentWhy are Calculation Groups so hard to modify?
Is there a way to make it easier to modify the DAX in a calculation group? I'm not sure if it's just me that finds this so annoying, but perhaps it's because I just started using calculation groups. ...AaronReasoner9 hours agoNew MemberNew8Views0likes0CommentsFeature Request: Add a Warning Prompt Before Deleting Tables That Contain Measures
Problem Statement: In Power BI, measures are linked to specific tables. When a developer deletes a table from the model view or report view, Power BI automatically deletes all measures assigned to ...Murtaza_Ghafoor12 hours agoSuper UserNew17Views2likes0Comments