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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
BSLATTER
Helper III
Helper III

Power BI Goals - Cannot use LOOKUPVALUE to get Parent Goal name?

Hello,

 

I am using a composite model of a Power BI Goals dataset and trying to create a DAX calculation to get the Parent Goal Name. So the Goals dataset is Import but I have taken a local "directquery" model of it to work on in a composite sense.

 

For reference I am following Radacad's blog post here: Radacad Org Hierarchy & Chart of Accounts 

 

According to what I've read - the functions I need (LOOKUPVALUE and PATHITEM) are not available for a DirectQuery dataset. I am looking to use them on the composite model. Is this possible?

 

If it's not possible - is there an alternative way of getting Parent Goal names from the Power BI Goals dataset?

 

Pinging @justynalucznik in case there is any insight here regarding Goals 

 

4 REPLIES 4
v-luwang-msft
Community Support
Community Support

Hi @BSLATTER  @justynalucznik 

 We cannot create calculated column with Lookupvalue function for the Direct Query mode table by my tests.

However, we could create the calculated column with Lookupvalue function for the import mode table.

In addition, we could create the measure with Lookupvalue function for the the Direct Query mode table.

You could try to use measure to have a test.

refer:

Lookupvalue function not appearing - Direct Query mode:

https://community.powerbi.com/t5/Desktop/Lookupvalue-function-not-appearing-Direct-Query-mode/m-p/45... 

What Happened To "Allow unrestricted measures in DirectQuery mode":

https://community.powerbi.com/t5/Desktop/What-Happened-To-quot-Allow-unrestricted-measures-in-Direct... 

 

 

Wish it is helpful for you!

 

Best Regards

Lucien

Thank you for responding.

 

The situation is that my dataset is Import - but I am "Live Connecting" to it from Power BI Desktop to build the report. Does that have the same limitations as "Direct Query" in this case?

 

If so - is there another way to get parent/child hierarchy out of Power BI Goals datasets?

Hi @BSLATTER ,

It is possible to create any measures when connecting to SSAS with Power BI Desktop (not Service).

Tutorial: Create your own measures in Power BI Desktop

 

But it would meet some limitations

Calculated measures when live connected to MDX cubes

"Using Analysis Services Tabular data in Power BI Desktop"

When connecting live, no data from the Tabular model is imported into Power BI Desktop.

Each time you interact with a visualization, Power BI Desktop queries the Tabular model and calculates the results you see.

In live connection,the measures you created aren't kept in-memory of the PowerBI tenant.

(using "Import" should be kept in-memory of the PowerBI)

Connect to Analysis Services tabular data in Power BI Desktop

vluwangmsft_0-1625794074557.png

 

 

Best Regards

Lucien

Thank you,

 

Sounds like the assumption was right - that "Live Connect to a Power BI dataset" has the same behaviours/limitations of a Direct Query dataset, even if the Power BI dataset is Import.

 

Is there an alternative way then of connecting to Power BI Goals dataset so that I can use those additional DAX capabilities?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.