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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
DamienK
New Member

Issue when importing an attribute of a dimension

Hi,

 

Context :

 

- I have an OLAP cube build with SSAS which is usable well in Excel
- I am on my analysis services server where Power BI desktop is installed.
- In Power BI desktop, I click on the "Modify queries" button
- I chose my server and my cube
- I select the attribute "Name" in the dimension "Customer"
- When I click on "Apply" I have the error (it is written in French)
         DataSource.Error : AnalysisServices : Le serveur a envoyé une réponse non reconnaissable.
         Détails :
         DataSourceKind=AnalysisServices
         DataSourcePath=servernam.domain;cubename
Translation : The Analysis Services server send a non recognized answer.
 
As you can see, the message does not mean anything ...
 
More precisions :
 
- I can retrieve all other attributes without any problem (ID, country ...), only the name is in error.
- In Excel there is no problem, I have all my customer names.
- In my database, I don't have some special characters or nothing else.
- When I retrieve the ID and the name, I found out that the ID=1050 went wrong, the name was "BEBE CASH (LIMOGE)", it is a normal name, some other very close where OK.

 

I tried some solutions :

 

- Modify some customer names with wrong characters (? ¨ for example)
- In Power BI, I tried to make a right click on the header of my column, delete errors, replace errors ... Does not work.
-  I tried to change the type of data
- I built my cube again and there is no eproblem with SSAS, my cube is deploy without error.

 

What is wrong with my datas ?

 

Thanks.

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@DamienK,

 

You may check the link below.

https://social.msdn.microsoft.com/Forums/en-US/64dacd38-aca5-4f4f-9aa6-66f1560ad497/getting-error-th...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Possidius
Regular Visitor

Bonjour Damien,

 

Je penses avoir le même probléme que le votre, par contre je suis assez nouveau dans l'usage de Power BI.

En effet tout fonctionne à part l'importation des noms clients (et la dimension des codes postaux).

J'ai le code suivant "

Erreur OLE DB ou ODBC: [DataSource.Error] AnalysisServices : Le serveur a envoyé une réponse non reconnaissable..

Mes données sont importées d'un Cube OLAP. Je n'ai aucun soucis quand je connecte un TCD. Je suis capable de les voir dans PowerQuery. Mais ensuite quand je veux les importer (noms clients + code postaux) en applicant les modifications, Power BI m'affiche le code erreur.

Merci

A bientôt

v-chuncz-msft
Community Support
Community Support

@DamienK,

 

You may check the link below.

https://social.msdn.microsoft.com/Forums/en-US/64dacd38-aca5-4f4f-9aa6-66f1560ad497/getting-error-th...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

You are a genius !

I went in my SSAS cube, selected my dimension, changed the InvalidXMLCharacters to Replace and now it works great !

 

Thank you,

Have a nice day.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.