Data Filtering about crm-powerbi-viewer HOT 10 CLOSED

window.Samples = window.Samples || {};
Samples.Filters = Samples.Filters || {};
/**
 * Filter on user by name whenever a specific page is shown.
 * 
 * Note: This resets the filter whenever the user navigates to the specific page. 
 * Remove the event logic and set the filter once to avoid resetting on every navigation.
 * 
 * Suggested modifications:
 * - In your own code you should check against page name and not displayname to avoid 
 *   breaking the code if someone changes the displayname
 * - Filters should be on ID and not name
 * - Using Xrm get name/id from current user or owner if view is embedded to a form.
 */
Samples.Filters.filterOnAccount = function (report) {
    report.on("pageChanged", function(event) {
        let page = event.detail.newPage;
        console.log(`Page changed to '${page.displayName}' (${page.name})`);

        if (page.displayName === "Pagina") {
var accId = window.parent.Xrm.Page.data.entity.getId();
accId = accId.replace('{','').replace('}','');
            const filter = {
                $schema: "http://powerbi.com/product/schema#basic",
                target: {
                    table: "accounts",
                    column: "accountid"
                },
                operator: "In",
                values: [accId]
            };

            page.setFilters([filter]);
        }
    });
}

window.Samples = window.Samples || {};
Samples.Filters = Samples.Filters || {};
/**
 * Filter on user by name whenever a specific page is shown.
 * 
 * Note: This resets the filter whenever the user navigates to the specific page. 
 * Remove the event logic and set the filter once to avoid resetting on every navigation.
 * 
 * Suggested modifications:
 * - In your own code you should check against page name and not displayname to avoid 
 *   breaking the code if someone changes the displayname
 * - Filters should be on ID and not name
 * - Using Xrm get name/id from current user or owner if view is embedded to a form.
 */
Samples.Filters.filterOnAccount = function (report) {
    report.on("pageChanged", function(event) {
        let page = event.detail.newPage;
        console.log(`Page changed to '${page.displayName}' (${page.name})`);

        if (page.displayName === "Pagina") {
var accId = window.parent.Xrm.Page.data.entity.getId();
accId = accId.replace('{','').replace('}','');
            const filter = {
                $schema: "http://powerbi.com/product/schema#basic",
                target: {
                    table: "accounts",
                    column: "accountid"
                },
                operator: "In",
                values: [accId]
            };

            page.setFilters([filter]);
        }
    });
}

var customConfig = {
	///////////////////////////////
	//
	// ITEMS THAT MUST BE CHANGED
	//
	///////////////////////////////

	// See documentation on how to register the application in Azure AD and get a client id.
	auth_client_id: "3acf6c02-83c9-49d7-8dd0-6ea3c1511035",


	///////////////////////////////////////////
	//
	// CAN USUALLY BE LEFT UNCHANGED 
	// (unless specified in the documentation)
	//
	///////////////////////////////////////////

    // How to perform authentication - valid values are "inline" or "popup". Default is "inline".
    // You should typically use "inline" on Dynamics 365 Online with users located in your Azure AD and "popup" when on-premise (might also be required if you have invited external parties to your Azure AD).
	auth_mode: null,

    // Auto-refresh access - may cause page reload if token cannot be updated silently. Default is true.
	auto_refresh_token: null,

	// Where to cache tokens. Valid values are 'sessionStorage' and 'localStorage'. Default is 'sessionStorage'.
	auth_cache_location: null,

	// Logging of Adal authentication process [Valid values are 0-3] (0=ERROR, 1=WARNING, 2=INFO, 3=VERBOSE). Default is 0.
	auth_log_level: null,

	// Log level for Power BI Viewer [Valid values are 0-3] (0=ERROR, 1=WARNING, 2=INFO, 3=DEBUG). Default is 0.
	// (is not affected by and does not affect auth_log_level)
	log_level: null,

	// Array of custom scripts to load. Functions in these scripts can be referenced for report filtering etc.
    custom_scripts: "../../new_/accountfilter?ver=1"
};

	// Array of custom scripts to load. Functions in these scripts can be referenced for report filtering etc.
    custom_scripts: "../../new_/accountfilter?ver=1"

	// Array of custom scripts to load. Functions in these scripts can be referenced for report filtering etc.
    custom_scripts: ["../../new_/accountfilter?ver=1"]