Forum Discussion

elbachaoh's avatar
elbachaoh
Frequent Visitor
4 years ago

Rename Columns - SQL Direct Query Datasource - Using Dynamic M query parameters

I'm using a direct query to an SQL data source = Sql.Database("localhost", "DBName", [Query=Text.Combine({"Select *From [DBName].[dbo].[",TimeData,"]"})])   TimeData is a Dynamic M query Parameter...
Need Help
elbachaoh's avatar
elbachaoh
Frequent Visitor
3 years ago

lbendlin I do not wish to remove the additional columns, on the contrary I want them to appear in my data model.

Any thoughts?

 

Thanks

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    That is not a sustainable approach. Think about unpivoting instead, it is much more manageable.