Error with blocking queries

[blink2210]

Hi,

I have created a Power BI report with multiple tables from datasources (Excel files) saved in Teams/Sharepoint.

All seemed to be working ok, until i tried to add one more table which is literally a date (it's needed to calculate the number of days left to plan a delivery and changes every time they plan the deliveries hence needing this to be added to the report import) but now when i try to refresh the data i get the error loading blocked by failues with other queries.

However i can't see any other failures with other queries.  The report keeps saying i have pending changes, but when i click apply (even after deleting this new table) the message wont go away.

I can add the data using a local copy of the file but this report will be published to be used - so the data needs to be in a sharepoint.  I just don't understand why i can't add this data 😞

Any help would be really appreciated.

[AnkitKukreja]

Hi! @blink2210 

Can you scroll down and see if any other table is causing the error, which is highly unlikely as per your ss I see a few of them have already been loaded. 

I would suggest trying deleting that table and clearing the cache and existing credentials and refreshing again.

[blink2210]

Hi,

I've tried clearing cache and credentials - makes no difference.

I've also noticed that when it applys the changes - it's not actually refreshing any of my tables (even when there's no errors)

I really don't know what else to try. 

[blink2210]

Hi,

apoligies I missed the comment about clearing cache (I'm in mobile) so I will try that and let you know how I get on.

thanks

Rebecca

[blink2210]

Hi,

all tables seem to load without error.  I've deleted the one table I want to add and I don't get the error.  But the message about applying updates still shows even though there is no updates to the report.