Forum Discussion
SQL POWER BI tutorial request
I have a current project of getting data from SQL database through direct query and creating dashboard. Also i need to create slicers that need to change the data dynamically. Please provide training links, tips and tricks. I tried finding online videos but nothing was helpful. Thank you.
Hi shavish
Can you please go through the below link.
https://youtu.be/CNIA1_J6Gvg?si=hX_2eTCSXzTXJcks
https://youtu.be/pFfWesNmE-o?si=jBpgJobQ3rr52LM4
Thanks
Hi shavish,
Thank you for bringing your query to the Microsoft Fabric Community Forum. Also, a big thank you to Dineshyad for providing those helpful video links.To get you rolling, here are some official Microsoft resources tailored to your project:
- Check out the Direct Query model guidance in Power BI Desktop guide here:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about- This walks you through setting up the connection and includes tips for optimizing performance.
- This walks you through setting up the connection and includes tips for optimizing performance.
- For slicers that update your data interactively, the Slicers in Power BI doc is a great starting point:
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers- It covers the basics of slicer setup and customization.
- It covers the basics of slicer setup and customization.
- If you want your slicers to filter the SQL query itself (super useful for Direct Query), explore Dynamic M Query Parameters:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters- This lets you tie slicer selections directly to your database queries for faster results.
- This lets you tie slicer selections directly to your database queries for faster results.
- To keep your dashboard snappy, consider using aggregations in your SQL database. The Direct Query guide above touches on this t can make a big difference with large datasets.
If you find this information useful, please “Accept it as a solution” and give it a “Kudos” to assist others in locating it easily.
Thank you.- Check out the Direct Query model guidance in Power BI Desktop guide here:
5 Replies
Hi shavish
Can you please go through the below link.
https://youtu.be/CNIA1_J6Gvg?si=hX_2eTCSXzTXJcks
https://youtu.be/pFfWesNmE-o?si=jBpgJobQ3rr52LM4
Thanks
Hi shavish,
Thank you for bringing your query to the Microsoft Fabric Community Forum. Also, a big thank you to Dineshyad for providing those helpful video links.To get you rolling, here are some official Microsoft resources tailored to your project:
- Check out the Direct Query model guidance in Power BI Desktop guide here:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about- This walks you through setting up the connection and includes tips for optimizing performance.
- This walks you through setting up the connection and includes tips for optimizing performance.
- For slicers that update your data interactively, the Slicers in Power BI doc is a great starting point:
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers- It covers the basics of slicer setup and customization.
- It covers the basics of slicer setup and customization.
- If you want your slicers to filter the SQL query itself (super useful for Direct Query), explore Dynamic M Query Parameters:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters- This lets you tie slicer selections directly to your database queries for faster results.
- This lets you tie slicer selections directly to your database queries for faster results.
- To keep your dashboard snappy, consider using aggregations in your SQL database. The Direct Query guide above touches on this t can make a big difference with large datasets.
If you find this information useful, please “Accept it as a solution” and give it a “Kudos” to assist others in locating it easily.
Thank you.Hi shavish,
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, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.
- Check out the Direct Query model guidance in Power BI Desktop guide here:
Hi shavish,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi shavish,
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 it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.