I have a SharePoint folder that we’ve created where we store some sales data that do not come from our system. These files are provided by a 3rd party in order to give us a better understanding of the whole market and how well some products are doing in each market. Here are a few remarks about our case:
Each of these files has only 1 month of data – we’ll have a file for January with just 1 sheet in it that will have all of the data for January.
These are all Excel files living a happy life in SharePoint – we get these files via email from the provider or can add by ourselves and then store them in our Office 365 folder or group every month.
All of the files have the same structure, but different sheet names – all of the files only have 1 sheet and all of them have the same headers, but in a real case scenario, I connect all of these files via Dataflows in Power Bi service then connect Power Bi Desktop with this DataFlow and create a report and publish to the Power Bi Service so if add something or do modification in the existence sheet it works ok but when I add the new excel file to that folder and refresh the Dataflow it's can't refresh and give me an error like this
Error: Expression.Error: The key didn't match any rows in the table. Request ID: 54de1ee2-8843-6928-8736-9834730c349d Activity ID: 2f88337d-c9fb-4930-b4b2-43b5c853169c
Kindly Help
Thanks in Advanced
