Forum Discussion

AverageAsker's avatar
AverageAsker
Helper I
10 years ago

Cannot save a query for live connection

I am building report based on Live data from my SQL Server's table, I imported a table which contains DateTimeOffset column and then added (in Power BI Desktop) a custom column by using this query: ...
Need Help
ChristianBroe's avatar
ChristianBroe
New Member
9 years ago

I just had the same issue on a column that I casted to another type. My problem was apparently just that the column then had no name:

 

Before:

SELECT CAST(Startdate as DATE).....

 

This solved it:

SELECT CAST(Startdate as DATE) as Startdate

 

Basically a very stupid error message. Not sure if it applies to your problem but it worked for me