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
Anonymous
Not applicable

GetTextByTag funtion equivalent in Power BI

Hello brilliant PBI community,

 

I need help regarding GetTextByTag funtion thats used I guess in frontend applications to get text from an image in a form. I got this sql code from the frontend, I want to know if there is a replacement for GetTextByTag in Power BI functions or something in SQL?

Part of the code is as following:

select GetTextByTag(td0.TEXTS, 'TX') from cdo_transdata td0

 

Thanks for your help in advance,

Meena

 

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 


@Anonymous wrote:

Hello brilliant PBI community,

 

I need help regarding GetTextByTag funtion thats used I guess in frontend applications to get text from an image in a form. I got this sql code from the frontend, I want to know if there is a replacement for GetTextByTag in Power BI functions or something in SQL?

Part of the code is as following:

select GetTextByTag(td0.TEXTS, 'TX') from cdo_transdata td0

 

Thanks for your help in advance,

Meena

 


I'm afraid power query is a tool for data transformation so we can't achieve this requirement using power query. You can use R script/Python script instead.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 


@Anonymous wrote:

Hello brilliant PBI community,

 

I need help regarding GetTextByTag funtion thats used I guess in frontend applications to get text from an image in a form. I got this sql code from the frontend, I want to know if there is a replacement for GetTextByTag in Power BI functions or something in SQL?

Part of the code is as following:

select GetTextByTag(td0.TEXTS, 'TX') from cdo_transdata td0

 

Thanks for your help in advance,

Meena

 


I'm afraid power query is a tool for data transformation so we can't achieve this requirement using power query. You can use R script/Python script instead.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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