pbiideas1
7 years agoNew Member
Status:
Needs Votes
While refreshing Data-source, it deletes the relationship between tables in PBI model
After refreshing the data source in Pbix file, data model we observed that relationship between the tables was missing, and this caused of data exposing across multiple customers. To investigate more, thought was on the updates that have happened in Power desktop version, where there are some settings as mentioned below in Options menu in PBI Desktop which might be causing this behavior. -> Import relationships from data sources -> Update relationships when refreshing queries -> Auto-detect new relationships after data is loaded When talking to Microsoft team, they suggest to unchecked the first two above options which prevents the auto relationship updates. A compromise was to consider a more direct dialog to the user to confirm if they really want to do this action, vs a beginning warning sentence surrounding the toggle.
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Add a Global Option to Disable Tooltips in Power BI Settings
Description Currently, Power BI provides an option to disable tooltips at the individual visual level. However, there is no global setting to disable tooltips across an entire report or throughout ...Murtaza_Ghafoor5 hours agoSuper UserNew6Views1like0CommentsIncrease or Make Configurable the Power BI Browser Tab Limit (Currently 20 Items)
Power BI users frequently work across multiple reports, dashboards, semantic models, notebooks, and Fabric artifacts simultaneously. The current browser limitation of 20 open Power BI/Fabric items re...sharadmahajan1 day agoRegular VisitorNew339Views21likes3Comments