How to create processed data using python or other library in power bi service?

[ssspk]

Hello Team,

I have a JSON/CSV file and its is imported in PBI,

Table: search_data

date	term	term.count
1/1/2025	working time regul	1
1/3/2025	working time              regulation	1
1/8/2025	smart work	1
1/12/2025	Smart Work	1
1/13/2025	smart w	1
1/19/2025	smart work	1

I have to process the above table and need to create a processed table like below image,
As of now i am processing the data(.csv,.json) in the databricks side and creating the catalog(table) in databricks and connecting the tables via power bi.

I am using RapidFuzz library of Python in databricks.

How can i do it in the Power Bi Service? Is there any possiblity to create similar things here with out use of data bricks.

I can use Matrix Build visual in Dashboard,

Thanks and Regards,

Siva

[Anonymous]

Hi @ssspk,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly  "Accept as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[Anonymous]

Hi @ssspk,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[Anonymous]

Hi @ssspk,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[Anonymous · Accepted solution]

Hi @ssspk,

Thank you for reaching out in Microsoft Community Forum.

Please follow below guidelines for achieving the desired result within Power BI Service without needing Databricks;

1. Leverage Power BI’s built-in Power Query Editor for text processing, like trimming, replacing, and matching terms using functions like Text.Contains, Text.StartsWith, and Text.EndsWith to clean and transform the data.

2.If you want to continue fuzzy matching with RapidFuzz, use the Run Python Script option in Power BI's Power Query. This allows you to apply the RapidFuzz library for fuzzy matching directly within Power BI.

3.After processing, use Power BI’s Matrix Visual to display the processed and grouped data, similar to the example you provided.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.