cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot find table

I got a strange one for you. I tried to get a new object (table) from Salesforce to see if it contains relevant information. In Power Query all looks fine and upon refreshing in my last 'Applied Steps', I see all my values. Well, those 999+ rows at least. 

 

Then I tried to apply my new table. I did nothing to the rest of my dataset, but got myself the following error. 

 

Untitled2.png

Case History - Pending is a familiar table to me and it did contain date values. So the issue? I no longer have that table. This as the Calculate required a second dataset to filter against it, but I found a way to bypass this problem. Therefore I no longer required this second table. Thanks to my double screen, hereby a side by side print screen of both the fields and the queries. 

 

Untitled.png

As you can see, there is no table called 'Case History - Pending'. Before I added my new table, I've refreshed my whole dataset and published it to Power BI Service where it is refreshing on its scheduled refresh without any issues. 

 

I've removed Attachment and refreshed the dataset. No errors. Reapplied Attachment, same error. 

 

Untitled3.png

I'm worried for 3 reasons :

 

1. There is apparently a validations procedure with a second table which is not related in any way to the Query I'm trying to apply into my dataset. 

2. There are still data fragments around in my Pbix that affect active Queries, calculations and validations. 

3. THERE IS STILL DATA EXISTING IN MY PBIX THAT SHOULD BE REMOVED... Smiley Sad

 

If you would be so kindly and fix this problem, that would be great.

Status: New
Comments
Moderator

Hi @DouweMeer

 

Please create a support ticket to let engineers look into the issue on your side. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu

Member

@v-qiuyu-msft 

I've created the tickey. Hopefully it will fix the problem eventually.