Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Table changed to Measure icon

‎01-16-2017 08:22 AM

Hi everyone!

 

I don't know how, but a table that a I have in my model changed to an Measure icon.

 

Sin título.png

 

How can I change this and how could it happen?

 

Thanks in advance.

Labels:
Message 1 of 10
6,011 Views
0
9 REPLIES 9
parry2k
Super User
Super User

‎01-16-2017 03:28 PM

This is weird. What is your data source?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 10
5,995 Views
0
parry2k
Super User
Super User
In response to parry2k

‎01-16-2017 03:31 PM

If your data source is analysis services then Measures folders will show as "Measure" icon. I think that what it is? I believe your dimensions icon looks like a regular table icon, correct?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 3 of 10
5,994 Views
0
Anonymous
Not applicable
In response to parry2k

‎01-17-2017 03:11 AM

Hi @parry2k. Thanks for your reply.

 

In this particular case, for this table, the data source is an Excel document. Yes, the dimensions are shown with the standard table icon.

 

It is really wierd, because when I just started this report, the initial icon was the known table icon, as ussual. Suddenly it changed to a measure icon. I don't really know why.

Message 4 of 10
5,979 Views
0
parry2k
Super User
Super User
In response to Anonymous

‎01-17-2017 09:15 AM

Very interesting, would like to know what happened here?

 

Do you have pivot table in excel?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 5 of 10
5,971 Views
0
Anonymous
Not applicable
In response to parry2k

‎01-17-2017 10:09 AM

It's not that it doesn't let me work, but it is really annoying that things like this happen with no reason.

Message 7 of 10
5,965 Views
0
v-sihou-msft
Microsoft Employee
Microsoft Employee
In response to Anonymous

‎01-18-2017 01:09 AM

@Anonymous

 

I guess you import Excel Workbook Content into Power BI Desktop. Since your workbook contains a model already, it supposes to have a similar measure group folder which is displayed with a sigma symbol in Excel.

 

3.PNG

 

This folder will appear in a calculator icon in Power BI Desktop.

 

4.PNG

 

Regards,

Message 9 of 10
5,950 Views
0
Anonymous
Not applicable
In response to v-sihou-msft

‎01-18-2017 06:51 AM

Hi @v-sihou-msft. Thanks for your reply.

 

The original data source, the Excel document, has only a few columns with data. After imported that data, a table was created with those columns, all under a table icon. After working a lot with the data, adding calculated columns and measures, the original table icon changed by itlself to a measure icon.

Message 10 of 10
5,943 Views
0
parry2k
Super User
Super User
In response to Anonymous

‎01-17-2017 10:46 AM

I hope someone else can share if they seen this and how they fixed it?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 8 of 10
5,964 Views
Anonymous
Not applicable
In response to parry2k

‎01-17-2017 10:07 AM

Hi @parry2k. No, I do not have a pivot table. This same thing, just happened againt to an other table. I starting to think that maybe it has to do something with the count of mesasures that you have under that table. It's just a guessing.

Message 6 of 10
5,968 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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

View All