Azure analysis service - single query multiple tables not working

Question

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.

Answer 1

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

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.