Forum Discussion
shavish
1 year agoHelper I
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...
- 1 year ago
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
- 1 year ago
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:
Dineshyad
1 year agoFrequent Visitor
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