Forum Discussion
Solved
Combining two columns based on numbers
Hi everyone, I'm a newbie when it comes to PowerBi but with some background in Excel. I have two tables (Sheet1), (Sheet2) that consist with matching numbers. I'm searching for a function to first g...
You can achieve the automation using Google Sheets and Google Scripts to copy the missing values from Sheet1 to Sheet 2 and then feeding this final sheet as the input to your PowerBI Dashboard.
Google Sheets can be set on auto-update where if the data in either sheet changes the other will have it copied with the help of triggers available in Google Scripts.
And there is a video on how to automate data refresh in PowerBI so whenever your dataset is refreshed in PowerBI the same will reflect in your dashboards. Hope this helps.
https://www.youtube.com/watch?v=-8NlEeIIRiQ
Did I answer your question? Mark my post as a solution!