Forum Discussion
Dynamically bringing in new data sources
Hi All, I'm having a bit of difficulty executing the below. My team stores data in different tables within a SQL database each financial year and i need to create a Power BI report that wil...
Starting with an Excel sheet is fine, although FYI that you could have started with Source = {"Sales_A", "Sales_B", "Sales_C"} for future reference. From there you need to add a custom column that uses the same code as the Source line of either your Sales_A or Sales_B query. Where you see "... Sales_A", you need to update it to be "..." & [Column1]. If you share that M code, a more specific suggestion can be provided.
Pat
Hi Pat,
Thanks for your help.
Here is the PBIX with the M code and the source data.
I tried to replicate your instructions but i think i'm inputting the [Column1] in the incorrect place.
Thanks in advance