SSAS Tabular, do not see table after import

Question

I am connecting to an Oracle database. I want to use a native sql query for my source as opposed to a table. I select a table cause I don't see an option to add a query, then once I have the connection I create a query using = Value.NativeQuery(... I see the data, looks good. I select import and close the query editor but no table. Anyone know why I can't see my table?

Any help appreciated,

Thanks

MIke

Answer 1

Hi,
Not sure where and how you have used the query, but you could try right click the Data Source and then choose Import New tables. Add a table

Also about Native query, you could try follow these steps ,see if the issue still there or not : Import data by using a native query

If you still have the issue, you could share us more details.

regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You could try create new project and follow the steps to test if it is a permission issue with your Visual Studio . And test with simple local data see if table appears.

Answer 3

Thanks for replying LukasYu-msft,

I followed the directions in your link "Import data by using a native query" above. I am able to import a table from my data source and see it fine. When I follow the directions for a Native Query. In the Power query window, my query works fine I see the data. I hit import ( or close and update), the query window closes and nothing more happens. My expression is not a table. I do see it under expressions. What am I missing? Can't figure out.

Answer 4

Have you follow the 4th step ?

To create a table, in Queries, right-click the query, and then select Create New Table. The new table will have the same name as the query