Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am getting an error "This query contains transaformation that cannot be used for a live connection". I am using CONVERT(VARCHAR(10), Date, 20) in my query and using DirectQuery option instead of import.
Also if you can add some link how to use query in porwer BI that will be useful.
Thanks in advance.
Solved! Go to Solution.
@PrakashGupta@hugoberry I got the information that DirectQuery works is by taking the user query and putting it into a subselect. In order for this to work, it needs to be able to reference columns in the user query by name. Duplicate names or names that are missing would prevent that from working. So this is effectively by design.
In your scenario, please specify a alias for that convert() results in T-SQL query as suggested in my first post.
Best Regards,
Qiuyun Yu
@PrakashGupta@hugoberry I got the information that DirectQuery works is by taking the user query and putting it into a subselect. In order for this to work, it needs to be able to reference columns in the user query by name. Duplicate names or names that are missing would prevent that from working. So this is effectively by design.
In your scenario, please specify a alias for that convert() results in T-SQL query as suggested in my first post.
Best Regards,
Qiuyun Yu
Hi @PrakashGupta,
Based on my tested in desktop version 2.45.4704.442 with DirectQuery mode, the T-SQL query below can works fine.
select CONVERT(VARCHAR(10), DateCol, 20) Col1 from [dbo].[DateVal]
In your scenario, I guess the issue my not related to Convert() function itself. The error message indicates there might have some action is not supported in DirectQuery mode. Please review the Limitations of DirectQuery .
Would you please share the T-SQL query you used in desktop? Except this query, is there any other queries or transform actions performed in desktop?
Best Regards,
Qiuyun Yu
As mentioned in my reply, you can replicate the issue if you don't give an alias to CONVERT call
@hugoberry Thanks for your prompt.
@PrakashGupta I already sent a email to consult this issue internally, will update to you if I get any feedback.
Best Regards,
Qiuyun Yu
When you say in your query, you are referring to SQL, correct?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.