Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We are in the stage of developing a custom connector for Power BI. Though we have a cube data structure, it don't bring us the data in cube format to us. Below we have added the sample data that we try to push as json to the navigator window. For now, we are sending it as table data, which we handle internally as the below image
However, we need end users to choose the data as a cube in the navigation window.
Sample data:
"pov": { "members": [ [ "Plan" ], [ "FY22" ], [ "Units" ], [ "Working" ] ] }, "columns": [ { "members": [ [ "Jan" ] ] }, { "members": [ [ "Feb" ] ] }, { "members": [ [ "Mar" ] ] } ], "rows": [ { "members": [ [ "P_TP" ] ] }, { "members": [ [ "P_TP1" ] ] } ]
}
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |