Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
LeaF
New Member

Dynamic data flow diagram based on natural lanquage query

Hi, I'm completely new to Power BI and are struggling to find the correct information for my project.

 

I have a series of weather based netCDF files that are stored in a datalake and fed through to a series of programs.

 

I would like to know if it is possible to use natural language query to create a visual represention (potnetially a data flow diagram) to quicky identify knock on effects if a particular data file or program has an identified error. The aim is to be able to efficiently assess potential risk and impacts if an error occurs and what knock on effects that may have.

 

If a NPL dynamic data flow diagram is not possible is there an example tutorial I can be directed to that will show me the next best option to acchieve my goal? 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@LeaF , I doubt that. You have Q&A visual, which can give answers and you can get visuals created later. Also, you can use Copilot (P/F64 onward ) to create new pages with a choice of visuals.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

2 REPLIES 2
v-xingshen-msft
Community Support
Community Support

Hi @LeaF  ,

Thank you @amitchandak  very much for the solution, to help you understand the problem, I gave some more detailed steps:

Sorry, but it is not possible to create data streams directly in natural language in power bi.

But I can write a complete example flow for your needs, hope that helps.
1.Get Data :

Open Power BI Desktop, click Get Data based on the data lake storage type, and then import the netCDF file information.

vxingshenmsft_0-1721107989111.png

 

2.Creating a Data Table:

Create a datasheet in Power BI that records the file name, table name, and their dependencies.

3.Manually map the data flow:

In the Power BI report view, use the inserted shapes and lines to draw a data flow diagram to mark the relationships between files and programs.

vxingshenmsft_1-1721108010548.png

 

4.Add monitoring:

After publishing to Power Bi Service, create a dashboard and use the dashboard to set alert values.

vxingshenmsft_0-1721108084133.png

Natural language can be used in this place, where it is only used for querying questions.

vxingshenmsft_0-1721108143190.png

 

5.Integrate Visio charts:

If you need more detailed charts, use Visio to create data flow diagrams and embed them in Power BI reports.

If you want to use the viso chart, I found documentation for you that may help with your question.

Add Visio Visuals to Power BI reports - Microsoft Support

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

 

 

 

 

 

amitchandak
Super User
Super User

@LeaF , I doubt that. You have Q&A visual, which can give answers and you can get visuals created later. Also, you can use Copilot (P/F64 onward ) to create new pages with a choice of visuals.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.