Forum Discussion

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
5 years ago

How to run queries on each SSAS DBs

To better describe my issue, I am trying to do a mimimum reproducible example in very few words so that someone willing to resolve this can take the MRE and try this out. Let's suppose I have two SS...
Need Help
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
5 years ago

v-xulin-mstf  thanks for looking into it and what I have gathered from the post that either Enabling "Include in report refresh" or Disabling "Include in report refresh" might fix the problem. I tried both, yet I see the following in each instances

 

Additionally I see the following in my Data Source Settings.

Recap:- I am trying to run a SSAS qury on each of my SSAS DBs(DB name starts with sales) and pass on the name of the DB as query parameter on each SSAS query.

 

 

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi smpa01,

 

Is your issue solved? If the issue has been solved, please adopt the solution to help others.

If you still have some question, please don't hesitate to let me known.‌‌

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    5 years ago

    v-xulin-mstf  please hold on, it has not resolved my issue. I am going to discuss this in a call with MS.