Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

getting data from various projects at once

Hello everyone,   I have prepared the powerbi file for one of the projects, where I get some of the data from Sharepoint and some of them from the SQL server. It works fine. There are plenty of p...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for the reply.

    Regarding the first option, should this function be created in M query and then inputs have to be given?(or in advanced editor)

    Do not have experience in M query so question could be very simple.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello,

    Just a quick question. Would that be possible to make it like a mini-application.  Some window pops up and asks for the project ID. After typing the user id, the table would be automatically created and merged(sharepoint one as well as SQL table). 

    P.S as I mentioned earlier for all the projects code would be same in advanced editor. The only change is project id(as want to apply the script to various projects, based on user's input)

     

    Thanks in advance for your assistance!