Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
yusif1999
Helper I
Helper I

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 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.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@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

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@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

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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!

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.

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.