Forum Discussion
basketballer202
5 years agoFrequent Visitor
Join a live data set to an imported table from SQL server (possible? or is there a workaround)?
Hello, Would like to understand if this is possible? Trying to link some data together: Task: (1) trying to retrieve relevant timestamps and columns from a live data source ('Get Data' -->...
- 5 years ago
Which month is this from?
If it is from Dec 2020 onwards, then yes
GilbertQ
5 years agoSuper User
This can certainly be done with the new composite models.
You will need to have the latest version of Power BI Desktop installed (Dec 2020)
And here are more details on how to achieve this: DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | Microsoft Power BI
basketballer202
5 years agoFrequent Visitor
Thanks Gilbert! Would 2.91.701.0 work as well? I have this version.
- GilbertQ5 years agoSuper User
Which month is this from?
If it is from Dec 2020 onwards, then yes- basketballer2025 years agoFrequent Visitor
awesome this works thanks Gilbert for your help!