Forum Discussion
Power BI UTF-8
Hi Anonymous - I have used translator , next time please post in english.
Power BI can sometimes misinterpret dates based on the locale and time zone settings of your data source and the Power BI Desktop/Service environment.
BigQuery Settings: Check if your BigQuery dataset is using the correct time zone (e.g., UTC).Power BI Locale Settings: Go to File > Options and settings > Options in Power BI Desktop and ensure that the Locale for import is set correctly (matching the date format in BigQuery).Service Time Zone: When using automatic refresh, Power BI Service might operate in a different time zone than your local desktop environment, which can affect how dates are displayed.
You can modify your SQL query in BigQuery to format the date as text, which can sometimes avoid interpretation issues when Power BI pulls the data.
Hope the above information helps.
Hi Anonymous - I have used translator , next time please post in english.
Power BI can sometimes misinterpret dates based on the locale and time zone settings of your data source and the Power BI Desktop/Service environment.
BigQuery Settings: Check if your BigQuery dataset is using the correct time zone (e.g., UTC).Power BI Locale Settings: Go to File > Options and settings > Options in Power BI Desktop and ensure that the Locale for import is set correctly (matching the date format in BigQuery).Service Time Zone: When using automatic refresh, Power BI Service might operate in a different time zone than your local desktop environment, which can affect how dates are displayed.
You can modify your SQL query in BigQuery to format the date as text, which can sometimes avoid interpretation issues when Power BI pulls the data.
Hope the above information helps.