Posted inData & Analysis

Why Is My Relationship Inactive in Power BI Desktop?

The Power BI Desktop tool now attempts to utilize bi-directional relationships when it can. If any ambiguity exists, some of your relationships may become inactive. If you are seeing inactive relationships (the dotted line), take a look in Advanced properties to see if the “cross filter…
Posted inDynamics NAV & BC Tips & tricks

SQL kill inactive NAV sessions

// KILL SQL INACTIVE SESSIONS FOR NAV APPLICATIONS // ONLY FOR SLEEPING SESSIONS a very Simple SQL Stored Procedure to 'kill' sql inactive sessions idle (sleeping) for 10 minutes related to "Nav Client" applications Bron : Around Dynamics NAV World Lees meer...