Select direct queries without merging

[tobiasmcbride]

Hi,

I am struggling with a problem regarding a SAP Hana database we are using together with Excel files. I have 4 separate queries from a cost database, one for each cost estimate (Budget, Estimate 1, Estimate 2 & Estimate 3).

Each of these are a direct query. The data gateway we have setup at the company works as long as these SAP Hana queries are DirectQueries and not imports. 

However I want to be able to easily select which cost estimate version is used with a variance calculation I have (actuals minus budget version) and which is dispalyed in visuals like tables. The easiest way I have found was to append/merge queries with a custom column on each query denoting it as that cost estimate version and then I can easily select using a slicer which version is used.

I want to avoid doing this as when I create a merged/appended query it changes to import mode for the table not direct query and throws up errors. Any ways you can think of doing this? To recap - be able to have separate direct queries for each of the cost estimates and be able to choose which ones then are compared without appending/merging?

[dax]

Hi @tobiasmcbride , 

I am not clear about your requirement, if you want to calculate different tables' result, I think you need to create measure for each table, then use slicer to switch them. if possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.