Forum Discussion

mushama's avatar
mushama
Regular Visitor
9 years ago
Solved

How to make a variable in connection string?

Hi all,   I've been using PowerBI for some time now and are familiar with building reports based on SQL data - for historic purpose.   Now, I have some restaurants and would like to get data for ...
Need Help
  • mushama's avatar
    mushama
    9 years ago

    Hi,

     

    I don't thnik I am skilled enough to find the right solution. I might decide to just use Power BI for historical data. Data I will manually upload once a week. It only takes a few minutes each time.

     

    I already have a real-time solution running at Klipfolio that works great. I will just add the klipfolio dashboard in an iFrame on my Sharepoint online portal.

     

    Thanks for asking and thanks all for your input.

     

    Kind regards

    Morten

mushama's avatar
mushama
Regular Visitor
9 years ago

Maybe you can tell me - I have absolutely no idea of what is the right way to do it.

 

So, if you have any good suggestion of a syntax you would be hero of the day if sharing it with me :-)

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi mushama,

 

In addition to Greg_Deckler's suggestion, you can also take a look at the sample of Scenario 1: Parameterising a Data Source in this article.

 

Best Regards,
Qiuyun Yu

  • mushama's avatar
    mushama
    Regular Visitor
    9 years ago

    Thank you - I just took a quick look at the article. It looks promising and I will have time to verify if I can use the solution during the next couple of days.

     

    I will let you know wheter it worked or not.

     

    Kind regards

    Morten

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      9 years ago

      Hi mushama,

       

      Is query parameter working in your scenario?

       

      Best Regards,
      Qiuyun Yu

      • mushama's avatar
        mushama
        Regular Visitor
        9 years ago

        Hi,

         

        I don't thnik I am skilled enough to find the right solution. I might decide to just use Power BI for historical data. Data I will manually upload once a week. It only takes a few minutes each time.

         

        I already have a real-time solution running at Klipfolio that works great. I will just add the klipfolio dashboard in an iFrame on my Sharepoint online portal.

         

        Thanks for asking and thanks all for your input.

         

        Kind regards

        Morten