Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply

Unable to send my data as a cube to Power BI via custom connector

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

Mohanasudharsan_0-1685631637174.png

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"
                            ]
                        ]
                    }
                ]
}

 

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.