Refresh Power BI Dataset just after data insertion in SQL table
In this video, we are learning “how we can refresh a Power BI dataset immediately after data insertion in SQL using SQL Job?”, “Why do you need it?” and “how to set it up?”. You will also see the usage of PowerShell script, Power BI Rest API, SQL Job and SQL Triggers.
-------------------------------------
Topmate Link to book call 1:1 - https://topmate.io/rakesh_nag70
-------------------------------------
Download doc for “creating SQL Job”: https://up-to-down.net/248698/DataQuery
Download PowerShell Script to Hit Power BI Rest API for refreshing Power BI Dataset
https://up-to-down.net/248698/DataQue...
Download SQL Trigger on SQL table for executing Job https://up-to-down.net/248698/DataQue...
Download Sample Data: https://link-target.net/248698/sample...
(Click on the link and once page opens, scroll down, and click on Free Access)
MY FAVOURITE POWER BI BOOKS
📗 Microsoft Power BI Cookbook - https://amzn.to/3NXVksH
📕 The Definitive Guide to DAX - https://amzn.to/3pD8x1C
📗 DAX Patterns - https://amzn.to/46CcBji
📕 Storytelling with Data - https://amzn.to/439VO4j
📗 Pro Data Mashup for Power BI - https://amzn.to/3D0pgz8
📕 Beginning DAX with Power BI - https://amzn.to/3D0e85m
📗 Pro Power BI Architecture - https://amzn.to/3rdz1Y3
📕 Supercharge Power BI - https://amzn.to/44gdJHV
MY GEAR
🪑 Fabric Gaming Chair - https://amzn.to/44bSDu7
🎙 Lavalier Microphone - https://amzn.to/44dRMt2
💻 Dell Laptop - https://amzn.to/43dnrJZ
Other Youtube Channel on Power BI in English
📺 / @dataquery70
GET IN TOUCH
📺 Website – https://biprogrammer.com
📧 Email me – [email protected]
🤵 LinkedIn Profile - www.linkedin.com/in/rakeshnag
🤵 LinkedIn Group- https://lnkd.in/fdPfsiz
#powerbi #dataanalytics #businessintelligence