Skip to main content
Solved

Passing a dynamic value as an additional column next to the output of the call it is used in?

  • October 11, 2024
  • 4 replies
  • 69 views

I am using a Power BI endpoint (https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history) where I need datasetIds to get the refreshes of that dataset. I am using the TimeXtender REST data provider, in which I loop over a list of dataset ids using a dynamic value. The problem is that in the output of the Get Refresh History endpoint the dataset Id is not included.

Therefore, my question is: Is it possible to pass a dynamic value used in a call as an additional column next to the output of the call? I don't see any option for this in the portal. If I were to extract the data using Power BI, I would do the call for every row in a table containing the required dataset Ids and expand the resulting column. This way, the original table column containing the dataset Ids will always be related to the dataset refreshes. Can I do the same using TimeXtender?

Best answer by Thomas Lind

Hi @jasperp 

If you look at the caching files, does they contain the value added as part of an URL or something similar?

UPDATE

This should be possible by using an XSLT to output the dynamic value along with the other relevant columns. You can use the dynamic value in the XSLT same way as it is used in other places.

View original
Did this topic help you find an answer to your question?

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • October 15, 2024

Hi @jasperp 

If you look at the caching files, does they contain the value added as part of an URL or something similar?

UPDATE

This should be possible by using an XSLT to output the dynamic value along with the other relevant columns. You can use the dynamic value in the XSLT same way as it is used in other places.


Forum|alt.badge.img
  • Starter
  • April 11, 2025

Hi ​@Thomas Lind,

 

Do you have an example what should be in the XSLT to output this value in a column?

 

Thanks,


Thomas Lind
Community Manager
Forum|alt.badge.img+5

Hi ​@Maarsen 

I think I have it shown somewhere else as well, but I can’t remember where it was so you can get it here as well.

In my Graph API data source I do not get the Group Id in my group members endpoint, so the way I got it to show up as a field in my endpoint was by adding it as a static node like so.

It will look like this in the XLST result.

</xsl:element><groupid>{id}</groupid>

You can pull in connection variables and similar the same way.


Forum|alt.badge.img
  • Starter
  • April 24, 2025

Thnx


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings