Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Is it possible to automate the process of 'close and load' in Power Query/Power BI, and subsequently save the file?
Background information:
My Power BI file is structured around a folder and its files/data. Whenever a new file is added to the folder, Power BI merges and transforms the new data with the existing dataset.
However, I am unable to see the new data in the table view; it is only visible in Power Query. As a result, I must manually execute the 'close and load' process whenever new data is added to the folder in order to view it in the table interface.
I hope this clarifies the situation.
Solved! Go to Solution.
Hi @ChristianAU
In Power BI Desktop, you can click the "Refresh" button to get the latest data. You don't have to go to Power Query Editor to perform the refresh.
In Power BI Desktop refresh of report visuals, data refresh, and schema refresh all happen together using
In Power BI Service, you can set a schedule refresh for a semantic model or refresh it manually.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi @ChristianAU
In Power BI Desktop, you can click the "Refresh" button to get the latest data. You don't have to go to Power Query Editor to perform the refresh.
In Power BI Desktop refresh of report visuals, data refresh, and schema refresh all happen together using
In Power BI Service, you can set a schedule refresh for a semantic model or refresh it manually.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
That should work automatically when you refresh the semantic model. Somewhere in either Power Query or DAX you have a limiter, a filter that you forgot about. Check your code.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
7 | |
5 | |
5 | |
5 | |
4 |
User | Count |
---|---|
12 | |
11 | |
9 | |
7 | |
6 |