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 ,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
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.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |