Dynamic data flow diagram based on natural lanquage query

[LeaF]

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? 

[v-xingshen-msft]

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.

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.

4.Add monitoring:

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

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

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 · Accepted solution]

@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.