Forum Discussion
Auto refresh in Power BI Desktop
Hi jeongs1,
1. For your scenario, we are unable to automatically refresh it, because PowerBI get the data offline.
2. >>I know I have to set up the query/program it the first time, but I don't want to do that everytime new set of data/excel file is added inside the folder.
In Query Edit Navigator, you try to comebine all mutiple files to one file? For the error message, please click refresh in Query Edit and check if it works fine.
3. Power BI Gateway is used to connect and refresh data in Power BI service. It acts as a bridge, providing quick and secure data transfer between the Power BI service and on-premises data sources that support refresh. Please review the articles below.
Getting started with Power BI Gateways
On-premises data gateway in-depth
Best Regards,
Angelia
Microsoft EmployeeHi jeongs1,
1. For your scenario, we are unable to automatically refresh it, because PowerBI get the data offline.
2. >>I know I have to set up the query/program it the first time, but I don't want to do that everytime new set of data/excel file is added inside the folder.
In Query Edit Navigator, you try to comebine all mutiple files to one file? For the error message, please click refresh in Query Edit and check if it works fine.
3. Power BI Gateway is used to connect and refresh data in Power BI service. It acts as a bridge, providing quick and secure data transfer between the Power BI service and on-premises data sources that support refresh. Please review the articles below.
Getting started with Power BI Gateways
On-premises data gateway in-depth
Best Regards,
Angelia
Hello v-huizhn-msft!
Thank you for your comment. Just one more question/comment.
Let's say I extract yesterday's data the following day and name it according to the date.
For instance, today, I'd export yesterday's data and name it "06-14-17 Report".
That report is then saved inside a folder called "Reports" which I'd use to get data from.
So for today, in my Power BI, I would have all the data up until two days ago becuase I wouldn't pull yesterday's data.
Now once I pull yesterday's data, place it inside the folder, how would I have power BI to include that excel file?
If there a way to do so? If not, is having a one huge excel file the only way to do so?
Much appreciate it.