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