Forum Discussion
Error with blocking queries
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.
4 Replies
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.
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.
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
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.
