SSAS Tabular, do not see table after import

asked 2020-09-28T20:53:09.36+00:00
Computer Mike 86 Reputation points

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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
992 questions
{count} votes

4 answers

Sort by: Most helpful
  1. answered 2020-09-29T03:29:56.72+00:00
    Lukas Yu -MSFT 5,796 Reputation points

    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.

    No comments

  2. answered 2020-10-01T07:11:01.457+00:00
    Lukas Yu -MSFT 5,796 Reputation points

    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.

    No comments

  3. answered 2020-10-01T12:01:11.297+00:00
    Computer Mike 86 Reputation points

    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.

    No comments

  4. answered 2020-10-09T02:28:02.157+00:00
    Lukas Yu -MSFT 5,796 Reputation points

    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

    No comments