Skip to main content

Hello!

I'm trying to develop a PowerBI dashboard but encontered some situations where it's impossible to not expand new columns or lists from the nodes (foreign key from dimension table is inside the node) and I understand this drops the performance considerably (sometimes even turns impossible to load the table) of the model in the dashboard.

Is there a way to query the data straight from the connector? I know there's the possibility of making simple filter queries but I wasn't able to use other type of OData queries that exists. We need a solution that simplifies this since currently it's impossible to load more complex data models into PowerBI without expanding the nodes.

Please understand that I want to keep this situation as low code as possible, so an API or SDK solution is not an option.

Thanks!

Hi @Tatiana Marie Sakata,

I hope the question has been answered in the thread below.

 

 

 

@Dilini Fernando It hasn't.

Hi @Tatiana Marie Sakata ,

We are working on a new Power BI connector that allows you to write Graph QL in the queries which gets data joined by edges in a single query. With the current OData based Power BI connector, Power BI issues an additional query for each edge to be expanded, which is very slow. The new connector has been tested on this kind of use case and the query time went from minutes to seconds for the same expansions.

My colleague @Everton Colling should be able to give you more details on the new connector and how to set up such a query in Graph QL if you need it.

Reply


Terms & ConditionsCookie Settings