I have added some columns to a Report Database dbo. and when i execute the query , all works well, but when refreshing the data source they pull through as measures not dimensions and as number # format which I cannto change to string ?
Can you give an example of some of the fields and their data types in SQL? Could you also share a screenshot and/or a packaged workbook to show the problem?
Retrieving data ...