cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adanecito Helper IV
Helper IV

AI Power Query...

Hi All,

I am using Power BI Desktop & Python AI library I  wrote to do a quality analysis of the Database Design. I am wondering if AI Power Query can do simple things like split apart column names intellegently.

Also, it would be good to be able get meta data about the database for say a Data Calalog and compare words or phrases to a data dictionary. Just some things I am doing that would be great to have built into Power BI Desktop.

 

Thanks!

2 REPLIES 2
Community Support
Community Support

Re: AI Power Query...

Hi adanecito, 

I am not clear about your requirement, did you mean that you want to split column name, right? If so, you need to set "Headers  as first Row", then  use split function to achieve this goal, then  you need click "use first row  as header".

Best Regards,
Zoe Zhi

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

adanecito Helper IV
Helper IV

Re: AI Power Query...

Hi Zoe,

When doing quality checks of a Database design usually there is a naming conventions standard. When checking hundreds of tables you can save plenty of time using AI especially where it can break apart compound column names. I did that by using a Python AI library. But since Power BI Service does not allow for use of Python or R it made it impossible to use those languages for quality check reporting in the cloud.

 

That I hopes answers what I was doing there. The other question has to do with using AI to help build meta data and context association for databases.

 

Best Regards,

-Tony

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors