Forum Discussion

AnttiKai's avatar
AnttiKai
Frequent Visitor
5 years ago
Solved

Cannot find table - accidentally removed data table from direct query source

Hey all, first time for me at the power BI forums! I've got a report based on a dataverse dataset with a direct query connection. I used to do testing of visualisations with a test table in Datave...
Dataflow
Need Help
  • AnttiKai's avatar
    AnttiKai
    5 years ago

    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.

AnttiKai's avatar
AnttiKai
Frequent Visitor
5 years ago

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.