Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
taniabc
New Member

Brazilian Portuguese

When I select an item from the list of Slicer that has Portuguese characters, I get the error:

"Erro de OLE DB ou ODBC : [Expression.Error] Não foi possível dobrar a expressão para a fonte de dados. Tente uma expressão mais simples.."
Only the item that has no Portuguese characters are ok.
 
PB Desktop is Brazilian Portuguese, and Regional Settings is Brazilian Portuguese too.
 
Details:
Feedback Type:
Frown (Error)
Timestamp:
2018-12-05T16:51:34.3186723Z
Local Time:
2018-12-05T14:51:34.3186723-02:00
Session ID:
56978506-14dc-46c9-9bf0-953b71877de6
Release:
October 2018
Product Version:
2.63.3272.40461 (18.10) (x64)
Error Message:
Erro de OLE DB ou ODBC : [Expression.Error] Não foi possível dobrar a expressão para a fonte de dados. Tente uma expressão mais simples..
OS Version:
Microsoft Windows NT 10.0.17134.0 (x64 pt-BR)
CLR Version:
4.7 or later [Release Number = 461808]
Peak Virtual Memory:
38.1 GB
Private Memory:
429 MB
Peak Working Set:
570 MB
IE Version:
11.407.17134.0
User ID:
c46f9300-2827-4335-b5bd-9c36ffbdec67
Workbook Package Info:
1* - pt-BR, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Model Default Mode:
DirectQuery
Snapshot Trace Logs:
C:\Users\49910620987\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1477811634.zip
Performance Trace Logs:
C:\Users\49910620987\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Disabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_compositeModels
PBI_showManageAggregations
PBI_FuzzyMatching
Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
Formulas:

section Section1;
shared fat_receita_orcamentaria_coedt_udesc = let
    Fonte = Impala.Database("xxx.xx.xxx.xx"),
    dcog_share_Schema = Fonte{[Name="dcog_share",Kind="Schema"]}[Data],
    fat_receita_orcamentaria_coedt_udesc_Table = dcog_share_Schema{[Name="fat_receita_orcamentaria_coedt_udesc",Kind="Table"]}[Data]
in
    fat_receita_orcamentaria_coedt_udesc_Table;
shared fat_sigef_despesa_execucao_udesc = let
    Fonte = Impala.Database("xxx.xx.xxx.xx"),
    dcog_share_Schema = Fonte{[Name="dcog_share",Kind="Schema"]}[Data],
    fat_sigef_despesa_execucao_udesc_Table = dcog_share_Schema{[Name="fat_sigef_despesa_execucao_udesc",Kind="Table"]}[Data]
in
    fat_sigef_despesa_execucao_udesc_Table;
shared fat_sigef_receita_udesc = let
    Fonte = Impala.Database("xxx.xx.xxx.xx"),
    dcog_share_Schema = Fonte{[Name="dcog_share",Kind="Schema"]}[Data],
    fat_sigef_receita_udesc_Table = dcog_share_Schema{[Name="fat_sigef_receita_udesc",Kind="Table"]}[Data]
in
    fat_sigef_receita_udesc_Table;
shared receitas_despesas_sigef = let
    Fonte = Impala.Database("xxx.xx.xxx.xx"),
    udesc_share_Schema = Fonte{[Name="udesc_share",Kind="Schema"]}[Data],
    receitas_despesas_sigef_Table = udesc_share_Schema{[Name="receitas_despesas_sigef",Kind="Table"]}[Data]
in
    receitas_despesas_sigef_Table;
3 REPLIES 3
Anonymous
Not applicable

Try to remove the special characters "á", "ç" and "õ" directly from your data source.

v-yuta-msft
Community Support
Community Support

Hi taniabc,

 

Seems like your data source is impala, right? What have you done before this error happens? Could you share more details in English?

 

Regards,

Jimmy Tao

Hi v_yuta-msft,

   Thank for your replay.

Yes I am using Impala to connect with our database.

I created a Slicer with the name of payment account (cod + description). When no one payment is selected, the data are shown correctly.

When I select an payment name without Brazilian character, such as "11 - Vencim. e Vantagens Fixas - Pessoal" the data are shown correctly. But, if I select a payment name with Brazilian characters, such as "14 - Diárias - Civil" or "13 - Obrigações Patronais", I receive the error message.

 

erroSlicer.png

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.