Forum Discussion
Helper ICan you link an SQL Table to Cube / warehouse data?
Hello,
New to Power BI / DW / Cubes, so not sure the approach to take for this question. I have a query against our DW cube that returns totals for the departments (BDS, BGM, etc.).
However, the TRT department data needs to pull from a SQL DB table to provide a more accurate count. The warehouse / cube isn’t being updated at this point to have the correct TRT data. What is the best approach to take 1 column from a SQL Table to include in the above visual. Is there a Dax way to link and pull from the SQL table? Or how would you link an SQL Table to cube data?
Thank you in advance,
Matt
2 Replies
- amitchandak
Super User
DataFunness , Not very clear, but you should be able to create a measure to limit of SQL Table to date which max from the cube.
DataFunnessHello amitchandak ,
That is where I am confused. I will create a measure in the SQL Table, but how does the cube query link to the sql table?
