Help in Power Bi Query writing

[kishordute]

I have source data in dremio and excel base data base uploaded in the power bi workbook.

Now I am trying to build a SQL query which will process in the source section, where the data from Dremio and e Data loaded from Excel will work as table in this query.

E.g. 

Source = Value.NativeQuery(Dremio.DatabasesV370("dremio.com:1010", "Disabled", null, null, null, []),

              "Select * from Dremiodatabase LEFT JOIN" & EXCEL_DATA & "ON  Dremiodatabase.Unique = EXCEL_DATA.Unique"

Here highlighted in red EXCEL_DATA actually works as refrence to the table imported in power bi.

However  while excuting the query  getting this error :  (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

Please help!

[kishordute]

Dremiodatabase has more than 10 L of rows data and EXCEL_DATA have 84K of rows data

[lbendlin · Accepted solution]

Those are small tables. Load them as is and do the filtering in DAX.

[lbendlin]

Do as they ask. Rebuild this data combination.

How many rows in the "Dremiodatabase"  table?