Forum Discussion
Help in Power Bi Query writing
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!
Those are small tables. Load them as is and do the filtering in DAX.
3 Replies
Do as they ask. Rebuild this data combination.
How many rows in the "Dremiodatabase" table?
Dremiodatabase has more than 10 L of rows data and EXCEL_DATA have 84K of rows data
Those are small tables. Load them as is and do the filtering in DAX.
