Multiple errors when refreshing data

[Nathan_Hudson]

Hi everyone

I have been tasked to look after our PCS report.

I am new to PowerBi so am a little lost

I have 2 error sets that occur when I refresh the data. I dont have any question marks or tobelerones on the query editor, so not sure where to start. I assume that it is a common table/query that is linked to others that is causing the issues.

Error set 1

DimDate

Load was cancelled by an error in loading a previous table.

Query1

Load was cancelled by an error in loading a previous table.

Lines

Load was cancelled by an error in loading a previous table.

Kettle Quality

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.

Factory prod

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.

Actions

Column reference to 'Date' in table 'DimDate' cannot be used with a variation 'Date' because it does not have any.

SMAT_Schedule

Load was cancelled by an error in loading a previous table.

Supply chain targets

Load was cancelled by an error in loading a previous table.

Supply Chain Daily

Load was cancelled by an error in loading a previous table.

Latest Refresh

Load was cancelled by an error in loading a previous table.

OrderInfo

Load was cancelled by an error in loading a previous table.

Unit Products

Load was cancelled by an error in loading a previous table.

Quality

Load was cancelled by an error in loading a previous table.

Bag weight data

Load was cancelled by an error in loading a previous table.

Packer number

Load was cancelled by an error in loading a previous table.

!Zero

Load was cancelled by an error in loading a previous table.

Machine stop

OLE DB or ODBC error: [DataFormat.Error] Invalid cell value '#REF!'.. An unexpected exception occurred.

Append1

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.

mtube7

Load was cancelled by an error in loading a previous table.

Main

Load was cancelled by an error in loading a previous table.

LM3Benchmarks

Load was cancelled by an error in loading a previous table.

TubedBenchmarks

Load was cancelled by an error in loading a previous table.

KettleBenchmarks

Load was cancelled by an error in loading a previous table.

OEETargets

Load was cancelled by an error in loading a previous table.

tblReleaseWorkOrders

Load was cancelled by an error in loading a previous table.

General targets

Load was cancelled by an error in loading a previous table.

BinStocks

Load was cancelled by an error in loading a previous table.

Manning

Load was cancelled by an error in loading a previous table.

PackingTonnes

Load was cancelled by an error in loading a previous table.

Compressed air usage

Load was cancelled by an error in loading a previous table.

Energy Usage

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.

Unit production

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.

tblWCMTools

Load was cancelled by an error in loading a previous table.

tblsafetyenvironment

Load was cancelled by an error in loading a previous table.

tblenvironment

Load was cancelled by an error in loading a previous table.

Process stats

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.

PackingTonnes (2)

Load was cancelled by an error in loading a previous table.

All Sums

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.

Despatches

Load was cancelled by an error in loading a previous table.

ProductCodes

Load was cancelled by an error in loading a previous table.

mlmthree

Load was cancelled by an error in loading a previous table.

SupplyChainTargetsDay

Load was cancelled by an error in loading a previous table.

Energy Target

Load was cancelled by an error in loading a previous table.

Query parameters

Error set 2

Kettle Quality

Query 'Kettle Quality' (step 'Renamed Columns') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

Factory prod

Query 'Factory prod' (step 'Changed Type') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

Machine stop

Query 'Machine stop' (step 'Removed Duplicates') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

Thanks

Nathan

[Nathan_Hudson]

Hi rubayatyasim

I am not getting any errors in the actual query steps.

We have found that the report pages aren't actually being updated when we use the refresh button (on the top task bar) but is refreshed when we complete this individually.

Thanks

Nathan

[rubayatyasmin]

But, your error messages depict differently. It is showing the actual steps where the errors are being caused. Solve error set 2 and the rest of the problem should be solved automatically or you will find another error message that will be easy to troubleshoot. Also, I guess the tables that are not loaded, are connected to error set 2 queries. 

[rubayatyasmin]

Hi, @Nathan_Hudson 

The errors here are precise and also mentioned the query steps that are causing the error. Start from any query that is causing the error. If the error is connected or happening from another query then you will understand it. Try checking the other queries also.