Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Import Data from Multiple Data Source and Servers

Hi All, I need to make a Dashboard, which Import Data from only one Server (from 2 servers) and only one Table (from 3 tables) On Demand (Create by QUERY and Parameters).   I need to know : 1. ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Yes, you would do this via Query Parameters and then use those query parameters in your Source and/or Navigation line(s).

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Greg,

    Good to hear :)

    Can you recommend me on books/blogs/youtube or

    any other data source to get practical knowledge to solve this issue ?

    I know how to use parameters and SQL Procedure.

    However, I don't have all the knowledge how to deal with that.

     

    hope for respond.

     

    tks a lot !

    Dan

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Lydia,

        Tks for your respond.

        But it's not what I meant.

         

        Let me clarify.

        When client will open Power BI the next follows will appear:

        1.Choose Country: USA \ GERMANY

        2.Choose Report Type: Daily\Weekly\Monthly 

        3.From Date:

        4.To Date:

         

        Afterwards,

        According to those parameters the query  will act - Go to server and relevant table.

        All the process of choosing server and table will be Behind the Scenes
        (server name and table name don't show in any stage of the process)

        see the next simlar example in picture:
        in this example I create SQL Procedure which received User Name, Password and dates and get the data.

        (in this case data are imported from only one server and one table.
        therefore it's not create trhe flexibility as I expect.
        I as sumewe should use Dummy Variables In SQL Statement (see in picture)
        and use M Query as you mentioned.

         

         

        Hope For respond.

         

        Tks,

        Dan