Remove auto relationships between mandatory columns when importing from Dataverse
Love Dataverse, we have many complex models running. the problem we have is every time you connect to a new Dataverse it bring in all the mandatory columns, OwnerID, last Updated etc If your Power Bi report has many tables this leads to a huge amount of manual cleaning up in Power Query or in desktop. You have two choices either load up the tables and import then you have to remove all the autogenerated connections or alternatively load it without auto relationships and end up building all the relationships by hand. Either way you also have to go in and manually remove all the mandatory columns from every single table loaded (we have 60+) There should be an option on loading data to exclude certain column names from being included in the auto relationship detect such as index columns, mandatory Dataverse columns etc. In addition for dataverse connections you should be able to select which mandatory columns you bring in for all tables in one simple interface that covers all tables. This would take a day of work or more out of setting up a DV connection for a complex model.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Fix Direct Lake semantic model binding in Deployment Pipelines
When deploying Direct Lake semantic models via Deployment Pipelines, the Lakehouse source is incorrectly treated as an external SQL source. This results in broken lineage and prompts for credentials....lk1234 hours agoAdvocate INew1.5KViews27likes2Comments:: operator for typecast in T-SQL
Introduce support for the ::type cast operator in Fabric Data Warehouse as syntactic sugar for the existing CAST(... AS type) expression. The new operator would be functionally equivalent and compile...jovanpop-msft6 hours agoMicrosoft EmployeeNew47Views7likes2CommentsAllow calls of Fabric SQL Database stored procedures from Data Warehouse
It would be great if there were a possibility to call a SQL Database stored procedures directly from a Data Warehouse stored procedures. A use case for this would be e.g. logging activities and even...Vojtech_Dolejsi9 hours agoNew MemberUnder Review2.9KViews13likes2CommentsPower BI - Org apps and cross-report drillthrough
This idea is a request to provide cross-report drill-through capability for org apps. This means being able to navigate between reports hosted in different org apps. The following sections detail why...TomMartens10 hours agoSuper UserNew1.3KViews24likes3CommentsSemantic Model 'Make Changes to this Model'
The link or action item to make changes to the importing Semantic Model is to obscure. Nobody looks down in bottom right corner of the Power BI Desktop window unless they want to resize the current ...RobRayborn10 hours agoHelper IVNew3Views0likes0Comments