[Pablo Moreno]

Up

0

Down

::

There ae multiple ways to do this, but here is a quick solution to handle this.

Before doing this, duplicate the query, so you can see the impact before and after the transformation, as I’m sure you will need to adjust the end result.

You can use Power Query to transform and expand these lists into separate columns.

1. Open Power Query Editor:

   • In Power BI Desktop, go to the “Home” tab and click on “Transform Data” to open the Power Query Editor.

2. Select the Column with Lists:

   • Find the column that contains the lists of contact information.

3. Expand the Column:

   • Click on the expand icon (usually looks like two arrows) next to the column header. This will give you options to expand the list into new columns.
   • Select the fields you want to expand (e.g., Email, Name, etc.).

4. Handle Errors:

   • If there are errors in the expanded columns, you can use the “Remove Errors” option or filter them out.
   • You can also use the “Replace Errors” option to handle specific error values.

5. Clean and Transform Data:

   • After expanding the columns, you might need to clean and transform the data further to fit your needs. This could include renaming columns, changing data types, or applying additional transformations.

6. Load the Data:

   • Once you’re satisfied with the transformations, click “Close & Apply” to load the data back into Power BI.

[Pablo Moreno]

Up

0

Down

::

Have you tried to replicate those tables in SQL server, for example? You can use the BYOD feature to export the tables to Azure SQL Server and consume it at Fabric

[Pablo Moreno]

Up

0

Down

::

Thanks for sharing Victoria. We should do a presentation about DP700

[Pablo Moreno]

Up

0

Down

::

Editing the flow should not break anything. However, it is always recommended to review the flow and its dependencies before making any changes to ensure that any potential impacts are considered.

[Pablo Moreno]

Up

0

Down

::

Thanks for sharing @Victoria

We are preparing great things at the User Group!

[Pablo Moreno]

Up

0

Down

::

Thanks for sharing @Victoria

We are preparing a lot more educational resources and content around Fabric

[Pablo Moreno]

Up

0

Down

::

Thanks for sharing! Definitely in my roadmap now!

[Pablo Moreno]

Up

0

Down

::

Thanks for Sharing @Victoria

[Pablo Moreno]

Up

0

Down

::

this is a very nice resource. Thanks for sharing @Victoria

[Pablo Moreno]

Up

0

Down

::

Fantastic!

Thanks for sharing @Victoria

[Pablo Moreno]

Up

0

Down

::

Thanks for sharing this resource @Victoria

[Pablo Moreno]

Up

0

Down

::

Hello Larry,

I never tried that myself, but leveraging dataverse may help as it incorporates natural language search (including misspelling and common achronyms identification) What is Dataverse search? – Power Apps | Microsoft Learn

Not sure if LUIS (Language Understanding Integration Service from Azure) can be incorporated as part of the search option for the app user, but it could be a great case-scenario.

Thank you

learn.microsoft.com

Content Issue

Content Issue

[Pablo Moreno]

Up

0

Down

::

Thank you Victoria, these are awesome insights!

[Pablo Moreno]

Up

0

Down

::

Nice one on loading on-prem databases into Fabric!

Thanks for your insights

[Pablo Moreno]

Up

0

Down

::

Of course! There will be soon an article that will be published at Fabric UG and one of the things that I mention is OneLake and its implications in business.

Separatedly, I accepted the challenge and going at 83% 🙂 I must say that Microsoft did a great job with the learning path.

As you mention, very soon, together with @Victoria , we will be publishing key take-aways from that challenge!

Thank you @Bearded_Analyst