Forum Discussion
ssspk
Helper III
3 years agoRefresh dashboard once the data bricks tables are updated with the new data or Scheduled refresh?
Hello All, We have used Azure DataBricks as a data source to build the dashboard. We need to refresh the dashboard once the databricks tables are updated with the new data. (OR) Scheduled refresh...
tackytechtom
Most Valuable Professional
3 years agoHi ssspk ,
I suggest you create a notebook in Azure Databricks that calls the Dataset Refresh API in Power BI for your dataset right after all the tables in databricks have been loaded. Here a video for inspiration:
How To Refresh Your Power Bi Dataset Using Python? #python #powerbi #biconsultingpro - YouTube
If you orchestrate the loading of the notebooks in an ETL tool like Azure Data Factory, you could do the same via an Azure Data Factory Pipeline:
https://www.tackytech.blog/how-to-refresh-power-bi-datasets-from-data-factory-with-managed-identity/
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/