Forum Discussion
Help adding columns from another table to an existing query
Greetings, I am running the following query in PowerBi. It works well, but I need to pull data from another table, and add it to the output. highlighted below is the table & columns I want to extrac...
I see you already have multiple joins in your query. Why can't you just join on DCSQLPA01.Operations.dbo.ParkDailySchedules and select the 3 columns you need? Try the query with this new join directly on the SQL server for testing purposes. If it works, then you shouldn't face any issue importing it to Power BI
I tried that, maybe I am writing the the statement incorrectly?