Forum Discussion

JoshoDotNZ's avatar
JoshoDotNZ
Frequent Visitor
6 years ago

PowerBI Embedded - Dedicated Capacity Filter Issue

Hey Squad,

 

I have just ticked the box for my workspace to go to a dedicated capacity....

I am now getting this error

Uncaught 
Array(1)
0:
message: "filters property is invalid"
__proto__: Object
length: 1
__proto__: Array(0)

 

This is my Javascript

        <script src="Scripts/powerbi.js"></script>

        <div id="embedContainer" style="margin-top:10px; width:100%; height:700px"></div>

        <% Dim Model As New PowerBI.PowerBiConfig%>
        <% Model.Main()%>
        

        <% If Model.EmbedToken.Token IsNot Nothing Then %>
        <script>
        //Filtering Variables
        //var division = " = SessionHelper.DivisionID";
        var division = "SSA";
       // var department = " = Mid(SessionHelper.UserPermissionString, 69, 1>";
        var department = "";
        // Read embed application token from Model
        var accessToken = "<% = Model.EmbedToken.Token%>";

        // Read embed URL from Model
        var embedUrl = "<% = Model.EmbedUrl%>";

        // Read report Id from Model
        var embedReportId = "<% = Model.EmbedId%>";

        // Get models. models contains enums that can be used.
        var models = window['powerbi-client'].models;

        // Embed configuration used to describe the what and how to embed.
        // This object is used when calling powerbi.embed.
        // This also includes settings and options such as filters.
        // You can find more information at https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embed-Configuration-Details.

        const divisionFilter = {
            $schema: "http://powerbi.com/product/schema#basic",
            target: {
                table: "PBI_Division",
                column: "Divisions"
            },
            operator: "In",
            values: [division]
        };

        const departmentFilter = {
            $schema: "http://powerbi.com/product/schema#basic",
            target: {
                table: "PBI_Department",
                column: "Departments"
            },
            operator: "In",
            values: [department]
        };


        var config = {
            type: 'report',
            tokenType: models.TokenType.Embed,
            accessToken: accessToken,
            embedUrl: embedUrl,
            id: embedReportId,
            permissions: models.Permissions.All,
            filters: [divisionFilter, departmentFilter],
            settings: {
                filterPaneEnabled: true,
                navContentPaneEnabled: true
            }
        };

        if (division == "" && department == "") {
            config.filters = [];
        } else if (division == "") {
            config.filters = [departmentFilter];
        } else if (department == "") {
            config.filters = [divisionFilter];
        }

        
        // Get a reference to the embedded report HTML element
        var reportContainer = $('#embedContainer')[0];
    
          // Embed the report and display it within the div container.
        var report = powerbi.embed(reportContainer, config);
    

        </script>

 

Any ideas?

I have never have so many issues before moving from a working test envoriment to a paid version which stops working?

 

Thanks,
Josh Griggs

2 Replies

  • Hi JoshoDotNZ ,

     

    I'm not sure the filter issue is caused by the dedicated capacity. Still if you are dedicated capacity in other region than your tenant location, probabily you have to read this limiations.

     

     

     

    • JoshoDotNZ's avatar
      JoshoDotNZ
      Frequent Visitor

      Hey Jayendran 

       

      Both Tenant and Dedicated Capacity are host are in the same location.

       

      Hmmm I  well the issue only happened when ticking the box in the workspace to a dedicated capacity.

       

      Thanks,

      Josh Griggs