![]() Instead better option in most cases is to establish connection to SQL database in single PQ query, then reference that connection in one or many child queries. This blocks PQ potential, to fold query into native query. One tip: When you are loading data from SQL Server, it is not the best idea to execute SQL statement directly in connection string. Currency data type is not related to specific formatting, but to decimal with 4 digits after coma (fixed). PowerQuery does not resolve number format, as it is not intended for such purpose. As you can see the new added record is loaded to the worksheet and the formatting still remains. Now go and add a new record in the Production.Product table in SQL Server then refresh the Power Query. Select Properties from Connections ribbon from DATA tab in Excel and tick “Preserve column sort/filter/layout” option for the “Power Query – Query 1” connection and click OK.Close and load the query to a worksheet, then change the format cell of “ListPrice” column as currency. ![]() And as you also can see there is no formatting you can do for the “ListPrice” column. As you can see in the below image, Power Query considered it as a Decimal number. List price is a Money column in the Production.Product table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |