cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mkatipal Frequent Visitor
Frequent Visitor

data type change analysis services

Hi,

Am looking for ways to be able to change the data type of a Dimension attribute (like Resume number) from numerical to text data type. That will allow me to analyze some related facts.

I dont see any option as such.

 

Tool used- Power BI

Source - Analysis Services

12 REPLIES 12
mkatipal Frequent Visitor
Frequent Visitor

data type change for a field using analysis services as source

Hi,

Am looking for ways to be able to change the data type of a Dimension attribute (like Resume number) from numerical to text data type. That will allow me to analyze some related facts.

I dont see any option as such.

 

Tool used- Power BI

Source - Analysis Services

veejess Regular Visitor
Regular Visitor

Re: data type change analysis services

@mkatipal, In Power BI Desktop, click on 'Edit Queries' under the Home tab, then in the opened Query Editor window, you select the column by clicking on it, then change the 'Data Type' (under Home tab) to Text.

wwhittenton Regular Visitor
Regular Visitor

Re: data type change analysis services

Hi @mkatipal,

 

To change the data type, you have a couple options. You can, in the Data view (left side button that looks like a table), click on the column you would like to change the data type, then select the Modeling tab and choose the "Data Type" dropdown in the formatting section.

 

Alternatively, go into the Query Mode by clicking on the Home tab at the top, then "edit queries". From there, the "transform" section will have a Data type dropdown you can select.

mkatipal Frequent Visitor
Frequent Visitor

Re: data type change analysis services

Is this applicable for Analysis Services as well?

I clicked Edit Queries option in the Home tab and I have only the Data Source Settings option available. Upon clicking that it goes to a window where i need to login to the model/data source

wwhittenton Regular Visitor
Regular Visitor

Re: data type change analysis services

I couldn't say for sure about Analysis Services.

 

When you go into Edit Queries, have you selected the table and column you would like to change the data type of?

Highlighted
mkatipal Frequent Visitor
Frequent Visitor

Re: data type change analysis services

biCapture.JPG

This is all I see.

Once I click the Data source Settings, It opens a window to enter Server name and Database name for Analysis services DB's

v-jiascu-msft Super Contributor
Super Contributor

Re: data type change analysis services

Hi @mkatipal,

 

Your model is a live connection to SSAS that is also a powerful analysis tool. Since it's a live connection, you can't define or modify the model in the the Power BI side. You need to do it in the SSAS. Please refer to desktop-directquery-about/#live-connections.

 

>>>However, unlike DirectQuery, there is no sense in which a new model is being created; in other words, it's not possible to define new calculated columns, hierarchies, relationships, and so on. Instead you are simply connecting directly to the external SSAS model.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jiascu-msft Super Contributor
Super Contributor

Re: data type change analysis services

Hi @mkatipal,

 

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

 

Best Regards!
Dale

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

Re: data type change analysis services

Hello,

 

I am also having this problem. I prepared a report with SSAS live connection and I need to change one column's data type to "Barcode", but I can not do it at this moment.

 

Did you get the proper solution?

Best regards.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 354 members 3,054 guests
Please welcome our newest community members: