getting data from various projects at once

[yusif1999]

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 projects, instead of creating for each project separate powerbi file, I am just thinking if it is possible to input variable to powerbi script. The only change would be within ID of the project.(one for sharepoint and another for SQL)

In other words, want to just input different ID and get the table for that project accordingly.

All the projects have the same structures, column names ect.

[Greg_Deckler · Accepted solution]

@yusif1999 Well, 2 approaches. You could create a function that returns the table for a project and create a query that appends all of the data together in a table/tables. The other option is to use dynamic M query parameters:

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Docs

[yusif1999]

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!

[yusif1999]

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.