Forum Discussion
SQL POWER BI tutorial request
- 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:
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.