Forum Discussion
getting data from various projects at once
Anonymous 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
Anonymous 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
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.