Azure analysis service - single query multiple tables not working

Kumar, Ajay 21 Reputation points
2022-03-25T05:05:35.743+00:00

I am migrating SSRS reports to power BI. In the process i am creating models in Azure analysis services.
I created the project in visual studio > then > Expression > Edit Expression > Query > New Query > Blank Query.
Here i wrote my SQL query which was used in SSRS. And i am able to get the data which is shown in the grid > Then i selected "import" from the top.
It should have created the table in my project but it doesn't create anything.
How can i create the model using the query so that i can use it in my Power BI report.

186793-image.png

186700-image.png

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
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.
1,255 questions
{count} votes

Accepted answer
  1. ZoeHui-MSFT 34,576 Reputation points
    2022-03-25T08:37:04.51+00:00

    Hi @Kumar, Ajay ,

    Enter a query as a named expression

    1. In Tabular Model Explorer, right-click Expressions > Edit Expressions.
    2. In Query Editor, click Query > New Query > Blank Query
    3. In the formula bar, type
      = Value.NativeQuery(#"DATA SOURCE NAME", "SELECT * FROM ...")
      4.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.

    Details you may refer:

    ssas-import-query

    186808-123.png

    You must click on the Create New Table otherwise it will create the expressions as shared in your image.

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful