Forum Discussion
Cannot find table - accidentally removed data table from direct query source
God thanks awhhh, I fixed it with such bubble gum that it's hard to believe 😄
The error reports gave 1-2 errors at a time for the data source, tables or columns that didn't exist anymore. There was more conflict / querys for non-existing table columns than I could first remember. One by one I created those back to dataverse as dummy-columns that existed again for respective tables with similar properties but with no data. After some "fixes" power bi seemed to decide that the data source was not "too much wrong" anymore, the file opened and I could fix the query to reflect changes in the data source.
So, the main issue here is still that the file doesn't open with PowerBI desktop, at all. Just pops that error message and closes the program. I've tried to look into the .pbix file by turning it into a .zip file and going through the contents. It seems quite unlikely that I could remove all mentions of the deleted table as it is mentioned in the file 1700+ times and not very friendly code.
The report file has some 100 hours of work in it that I could recreate in maybe 20 hours now that I've done it once. Such a pain if it's the only way.. Seems problematic that an unlucky change in dataverse tables prevents opening a DirectQuery pbix.-report file at all so that it could be modified.
Any ideas would be welcome
Regards