Azure analysis service - single query multiple tables not working

Kumar, Ajay 21 Reputation points

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.



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

    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:



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



    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