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
Render Markdown files in the Lakehouse explorer
Render Markdown files in the Lakehouse explorer. .md files under Files are shown only as raw text. Add a toggle between a rendered view (headings, tables, links, ideally Mermaid) and the source view,...Wouterdeleeuw26 minutes agoNew MemberNew2Views0likes0CommentsPower BI Admin to Disable the New Ribbon Preview & Control Rep Toolbar Visibility at Tenant Level
Allow Power BI Administrators to Disable the New Ribbon Preview and Control Report Toolbar Visibility at Tenant Level It takes too much real estate and by default users with low maturity leaves it a...icassiem1 hour agoPost ProdigyNew3Views0likes0CommentsShow the column name and row when refresh fails with OLE DB error 0x80040E1D
When refreshing a table, I get "OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D." The message does not show which column or row caused the error. With a table that has many columns, it is ve...HTakashi1 hour agoNew MemberNew1View0likes0Comments- axserv10 hours agoNew MemberPlanned9.2KViews145likes16Comments