Forum Discussion
Changing data source
Hi jagjrvcsny ,
Thank lbendlin for sharing, and I have some additional content here.
Please ensure that the Excel file names, table names, and identifiers match the initial data format and names used when creating the Power BI report, and note that Power Query needs to be case sensitive.
Solved: The key didn't match any rows in the table when ch... - Microsoft Fabric Community
Solved: Dataset not refreshing - The key didn't match any ... - Microsoft Fabric Community
The error is also related to the data format:
Solved: Data source error The key didn't match any rows in... - Microsoft Fabric Community
Find Data source settings in Power BI Desktop -- remove permissions and re-edit permissions
This is the related document, you can view this content:
Solved: Error on Power BI Service: The key didn't match an... - Microsoft Fabric Community
Solved: Expression.Error: The key didn't match any rows in... - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thank you. My data source is DB from Microsoft Access. I can create reports in Microsoft Access and new reports in PBI (I will be working on my old report because changing the data source is an issue). My goal now is to have a dashboard on PBI. Would you be able to refer me to a consultant who I can hire to create a dashboard?