Why Is a Table Not Being Created in the Semantic Model?

[jellis1971]

I'm really shocked by this. 

A couple of days ago, I created a simple Excel spreadsheet as shown in the screenshot below.

Afterward, I formatted it in the table "style" as you can see below.

Then, I uploaded this into the Power BI Service as a Semantic model.

Next, I went into Excel and navigated to Data...Get Data...From Power Platform...From Power BI.

On the right-hand side of the window, a helpful pane appeared allowing me to "Insert Table".

Today, when I take these steps with a similar spreadsheet, Excel does not see a table.  In other words, the Semantic model that I created today did not "upload" the spreadsheet as a table.

Why in the world not?

[jellis1971]

How do I solve the connection problem?

[jellis1971]

@aj1973:

The spreadsheet is loaded in Microsoft Teams.  What in the world is "DQ"?  🙂

[aj1973]

😀The world of Direct Query.

Where do you not see your table ? here 

[jellis1971]

I don't usually go to Direct Query, as I usually have no use for it.  So, how do I get there to answer your question?

[aj1973]

How !! are you asking me ?

I followed your instruction on how you did it

You are confusing me now, do you know what are you doing and what do you want to achieve?

[jellis1971]

I'm simply asking about your mentioning on the connection issue.  If your goal is to become sarcastic with me, then I very politley and profesionally ask that you ignore my posts from now on, so that I may receive the same professional support that I have always received and appreciated from this Forum.

Merry Christmas!  And, I don't mean "Happy Holidays".  LOL!

[aj1973]

Not at all, am being serious.

You are talking about 2 different things and am asking what do you want to do?

[jellis1971]

You mentioned a connection issue, as you circled the warning symbol.  Is that what's causing my problem in not being able to create a Power BI table for viewing from within Excel, then I need to know how to eliminate that issue.

[aj1973]

I am going to strat from the begging

Open Excel and Get Data from Power Platform

If it connects to the service then your ok

Else look for your dataset, if it is not on the list then click on button next to my bleu arrow and it will take you back to the service, if not then you have a connection issue.

If all good then pick your table and export it to excel

[aj1973]

Hi @jellis1971 

Where is the spreadsheet located? Is The connection mode of your semantic model to the spreadsheet in DQ?

Sounds weired you "World" 😀

[jellis1971]

After choosing to create a new Semantic model and browsing out to the Excel file in Microsoft Teams, below is what I get.  A warning symbol appears telling me that I don't have access to some sort of new features.

[aj1973]

You have a connection problem

you need to solve it