topic Re: Get Relathionships from Power BI REST API executeQuery in Developer

Get Relathionships from Power BI REST API executeQuery

marcio_fornari — Tue, 28 Jan 2025 12:57:29 GMT

Hello,I used to have this DAX code that I executed on the endpoint to retrieve dataset relationships, but now Microsoft seems to have blocked the execution of queries with INFO.*. Is there another way to get the relationships without using the INFO functions?

My querie:

DEFINE VAR _Table = SELECTCOLUMNS( INFO.TABLES(), "TableID", [ID], "TableName", [Name] ) VAR _Col = SELECTCOLUMNS( INFO.COLUMNS(), "ColumnID", [ID], "ColumnName", IF( ISBLANK([ExplicitName]), [InferredName], [ExplicitName] ) ) VAR _RelFrom = SELECTCOLUMNS( INFO.RELATIONSHIPS(), [ID], [FromCardinality], [IsActive], [CrossFilteringBehavior], [SecurityFilteringBehavior], "ColumnID", [FromColumnID], "TableID", [FromTableID] ) VAR _RelTo = SELECTCOLUMNS( INFO.RELATIONSHIPS(), [ID], [ToCardinality], [CrossFilteringBehavior], "ColumnID", [ToColumnID], "TableID", [ToTableID] ) VAR _FromRel = SELECTCOLUMNS( NATURALLEFTOUTERJOIN( NATURALLEFTOUTERJOIN(_RelFrom, _Table), _Col ), [ID], [IsActive], "From Table", [TableName], "From Column", [ColumnName], "From Cardinality", SWITCH( [FromCardinality], 1, "One", 2, "Many", "Something else" ) ) VAR _ToRel = SELECTCOLUMNS( NATURALLEFTOUTERJOIN( NATURALLEFTOUTERJOIN(_RelTo, _Table), _Col ), [ID], "To Table", [TableName], "To Column", [ColumnName], "To Cardinality", SWITCH( [ToCardinality], 1, "One", 2, "Many", "Something else" ) ) VAR _Result = SELECTCOLUMNS( NATURALLEFTOUTERJOIN(_FromRel, _ToRel), "From Table", [From Table], "From Column", [From Column], "To Table", [To Table], "To Column", [To Column], "Cardinality (From/To)", UPPER([From Cardinality]) & " row" & IF([From Cardinality] = "One", "", "s") & " in '" & [From Table] & "'[" & [From Column] & "]" & " matches to " & UPPER([To Cardinality]) & " row" & IF([To Cardinality] = "One", "", "s") & " in '" & [To Table] & "'[" & [To Column] & "]" ) EVALUATE _Result

This query works at Dax Studio for example:

Re: Get Relathionships from Power BI REST API executeQuery

lbendlin — Tue, 28 Jan 2025 17:12:59 GMT

See if the new INFO.VIEW* calls cover that.

Re: Get Relathionships from Power BI REST API executeQuery

marcio_fornari — Tue, 28 Jan 2025 17:54:26 GMT

The Microsoft blocked the INFO.* at this endpoint, any sugestion?

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries?tryIt=true&source=docs#code-try-0

Re: Get Relathionships from Power BI REST API executeQuery

lbendlin — Tue, 28 Jan 2025 18:02:52 GMT

Use the INFO.VIEW calls

Re: Get Relathionships from Power BI REST API executeQuery

marcio_fornari — Tue, 28 Jan 2025 18:08:34 GMT

I need execute the dax at this endpoint: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries

The microsoft BLOCKED the INFO calls here..

Re: Get Relathionships from Power BI REST API executeQuery

samsonfrb — Wed, 29 Jan 2025 14:17:59 GMT

We have the same issue since January 24, 2025. It stopped working with an Error 400 ...

I will open a ticket with Microsoft.

Frederick

Re: Get Relathionships from Power BI REST API executeQuery

lbendlin — Wed, 29 Jan 2025 15:04:24 GMT

Confirmed, We'll probably raise a ticket as well.

Re: Get Relathionships from Power BI REST API executeQuery

lbendlin — Wed, 29 Jan 2025 23:26:27 GMT

Here's what I got back:

I would like to let you know that Microsoft already found this issue and working on the fix, unfortunately there is no ETA information yet. Meanwhile, could you please follow this workaround given below and let us know if you have any issue. • If the model is in premium, customers might be able to switch their solutions to XMLA Endpoint-based connections and query semantic models by using the AS client libraries (ADOMD.NET).

Re: Get Relathionships from Power BI REST API executeQuery

samsonfrb — Mon, 03 Feb 2025 14:16:37 GMT

Yes, I got the same answer from them. The problem is still live as of today. Switching to XMLA Endpoint requires some work so we'll wait for the fix.

Re: Get Relathionships from Power BI REST API executeQuery

Anonymous — Tue, 04 Feb 2025 09:19:38 GMT

Hi all ,

Thank you for all your feedback! Once you receive the message that the problem has been fixed, please reply below and accept it as a solution so that more users facing the same problem can find a solution faster. Thank you!

Best Regards,
Dino Tao

Re: Get Relathionships from Power BI REST API executeQuery

marcio_fornari — Wed, 26 Feb 2025 20:32:52 GMT

Any updates about this?

Re: Get Relathionships from Power BI REST API executeQuery

lbendlin — Thu, 27 Feb 2025 01:05:39 GMT

Allegedly will be fixed by end of April, allegedly.

Re: Get Relathionships from Power BI REST API executeQuery

samsonfrb — Fri, 28 Feb 2025 13:41:09 GMT

In my case, it was taking too long and having too much impact.
I had to rewrite my PowerShell code to use AdomdConnection, AdomdCommand et AdomdDataReader via the XMLAEndpoint.