Hi, I ran into an odd behavior of Power BI Desktop. When either referencing or appending a query AND changing the Data Type of any column, the data was not correct anymore. Even more strange is th...
I am having the same issue. I have one query to a SQL Database and 2 queries to excel Files. I append this 3 queries with the same structure and apply some "Change Type" functions to some columns of the excel queries. The data from append query changes every time i click the refresh button. The differences are minimal, but after some tests i identify that some data disappear or duplicate instead. When i use only one source for the same data, all values are correct. Only the append query give different results for every refresh. Note: The data sources had no data changes between this refreshes. Sorry for any typing error
