Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi..... i am developing a report in PBI from a Dataverse table. One column has items that i want in a particular order. PBI automatically puts them in alphabetical order in a report. I tried adding a index column from 0, but when i tried, i got an error of:
"add column this query contains transformations that can't be used for directquery". For the Data Connectivity Mode, i selected DirectQuery. I didnt think importing in the data would be the best option as again, my datasource is MS Dataverse and only ONE table that over time will be big. I would think surely adding one column that is numbered wouldnt cause a problem as it is simply an index column.
Not sure what this means or how to fix it. Any ideas here???
Solved! Go to Solution.
@cnorris3570 , No you can not add a few types of the column in case of direct query-Simple addition, etc is supported as new column, You have to add that in the source
@cnorris3570 , No you can not add a few types of the column in case of direct query-Simple addition, etc is supported as new column, You have to add that in the source
thank you sir.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |