Forum Discussion
Folder Data Source Will Not Refresh - PLEASE HELP
I was able to work through this issue. The problem was I was selecting the file from the folder the incorrect way which was causing some merge issues. Thank you all for the quick responses.
Hi , kboyd
According to your error details, you have encountered the problem that the column "month_yr" from a table cannot be found during data refresh, according to my experience and research, you can try the following operations to confirm that the problem occurs root place:
1. You can try to download the report as a local .pbix file first and open it for a refresh
2. If the refresh reports an error, you can first go to Power Query to find the query with the problem and fix it.
3. If the refresh is successful, then we consider that the problem occurs in some row and column conversion operations in your query, because the refresh in Power BI desktop is a schema refresh, even if the data source data model of the source side changes, it can be refreshed successfully, but on the service is pure data refresh, the data source has any data model changes (such as column name change, column deletion, column order change, table name change) will have problems. You need to continue to research and troubleshoot these possible problem points
4. Here are some case links related to errors, you can refer to:
Solved: Re: Removing any columns causes errors - Microsoft Power BI Community
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly