![]() ![]() What we are after is to rename all columns from all tables. If we click on a cell (not on the Table value of the cell), we can see the actual underlying data, as shown in the following image: The Contents of a Table Value in Power QueryĪs the above image illustrates, the selected cell contains the actual data of the DimProduct table from the source. ![]() The structured values of the Data column are Table values. If we look closer to the Data column, we see that the column is indeed a Structured Column. The following image shows the results after applying the filter: Filtering out SQL Server Functions We are not interested in Functions therefore we just filter them out. The results would like the following image: The results of running the Sql.Database(Server, DB) functionĪs you see in the above image, the results include Tables, Views and Functions. ![]() So I connect to the SQL Server instance using the Sql.Database(Server, DB) function in Power Query where the Server and the DBare query parameters. In my case, my source table is an on-premises SQL Server. We require to connect to the source, but we do not navigate to any tables straight away. You already know how to rename all columns of a table in one go but you’d like to apply the renaming columns patterns to all tables. The columns of the source tables are not user friendly, so you require to rename all columns. You are connecting to the data sources from Power BI Desktop (or Excel or Data Flows). So I thought it is good to write a Quick Tip explaining how to meet the requirement. Interestingly enough, one of my customers had a similar requirement. One of my visitors raised a question in the comments about the possibility to rename all columns from all tables in one go. I previously wrote a blog post explaining how to rename all columns in a table in one go with Power Query. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |