Forum Discussion
Direct query, transformation and filters
Thanks for the reply. But, no. That did not help. Also, the pbix (and the credentials needed) is already shared in the original post (OP) itself. I am maintaining the demo SQL DB just for the users of this forum/question.
Now coming to suggestion of change data type :- Humbly requesting to take a second look at the query. It had two pbix. Working and Not working. The working pbix has infact changed the data type to text. The non working pbix has the data type in DATETIME itself. I don't want to change data type to TEXT since that impacts sorting by date. This is already mentioned in second paragraph of OP.
Hi Anonymous ,
A pbix file with Direct Query connection can't be opened by others. It will ask for relevant credentials to open.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am sorry to tell this. But have to tell. Have you read the query carefully atleast once? This is the second time I am asking you to read the query carefully. The credentials are already in the original query. I am not disappointed since there is no answer, that is ok. But I am disappointed since the kind of replies I am getting here appears like `checking if original poster is alive, if no we can close this ticket`
Hi Anonymous ,
I'm very sorry, I think I let you down, I will check it carefully.
Best Regards,
Stephen Tao