Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi ,I use Biq Query (database) and Direct Query. When I try to create visual with measures, an error occurs like "OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. ".
I read many topics about this , but l was not able to find solution to this problem.
Hi I met this mistake in another case.
I have slicer shop name in some report, when I choose one shop, It will calculate result.
But when I choose another It shows the same mistake. It is happened because Power BI is not able to create SQL query to Big Query.
Hi @pstanek,
Regards,
Ruslan
HI . I tried to refresh it and nothing has happened.
I have date and time formated as text
When I try to change type in Queryditor , Error will appear. Direct Query does not support it.
Measure is
Hodiny = HOUR(MAX(table[datumcas]))-HOUR(MIN(table[datumcas])).
When datumcas is text, it can´t calculate.
So I Try to change format here
and OLE DB or ODBC error: [Expression.Error] will appear.
Visual is only number, It represents hours between two events
let
Zdroj = GoogleBigQuery.Database(null),
#"bi-data-2073" = Zdroj{[Name="bi-data-2073"]}[Data],
data_lekarny_Schema = #"bi-data-2073"{[Name="data_lekarny",Kind="Schema"]}[Data],
table_View = data_lekarny_Schema{[Name="table",Kind="View"]}[Data]
in
table_View
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |