Forum Discussion

ysapiyev's avatar
ysapiyev
Responsive Resident
8 years ago

Global variable in Power BI

Hi everyone,

 

I have power bi report with ssas cube connected live. As I understand, I can't import tables from another source and etc. Is it possible to import global variable in report with live connection?

 

The purpose for this variable is to have dynamic dimenstion on graph, I found tutorial in internet, but they use calculated measures, which I can't import.

 

Regards,

Yerkhan 

Need Help

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi ysapiyev,

     

    If you are ussing a SSAS cube with a live connection you cannot make additional sources on your model, you can add measures to your model and have different calculations but not add additional tables.

     

    Can you please explain a little better waht result you want to achieve probably can help you achieve the measure you need to calculate in order to get it running without additional tables on your model.

     

    Regards,

    MFelix

    • ysapiyev's avatar
      ysapiyev
      Responsive Resident
      8 years ago

      MFelix,

       

      Hi,

       

      How I can enable feature of adding new measures? Currently, I can't.

       

      Actually, I want to have column with 4 text values, which I want to insert in slicer, and by changing slicer, data in my chart will change as well. It worked perfectly with imported tables from excel.

       

      Regards,

      Yerkhan

      • MFelix's avatar
        MFelix
        Super User
        8 years ago

        Hi ysapiyev,

         

        To add the measures you need to:

        • File
        • Options & Settings
        • Options
        • DirectQuery
        • Check the: Allow unrestricted measures in DirectQuery mode

         

        Add a new column with a live SSAS connectionis not possible.

         

        Regards,

        MFelix