Forum Discussion
Excel and SQL server direct query
MRRAC It isn't possible. You are not able to mix connection types. I would suggest loading the Excel file as a table in the database so that you can pull it in via DQ.
Anonymous Yes, this is still the case. The Desktop gets monthly updates (occasionally more for bug fixes). The Service is on a quicker cadence usually, I think it releases 2x a month, but for sure it is at least 1x.
How to create multiple realtionship with excel to sql direct qiery
getting message : You Can't create a direct active relationship between Table1 and Table2 because that would introduce ambiguity between tables table1 and table2 . To make this relationship active, deactivate or delete one of the relationship between table1 and table2
How to create multiple realtionship with excel to sql direct qiery
getting message : You Can't create a direct active relationship between Table1 and Table2 because that would introduce ambiguity between tables table1 and table2 . To make this relationship active, deactivate or delete one of the relationship between table1 and table2
How to create multiple realtionship with excel to sql direct qiery
getting message : You Can't create a direct active relationship between Table1 and Table2 because that would introduce ambiguity between tables table1 and table2 . To make this relationship active, deactivate or delete one of the relationship between table1 and table2
