Hi I am new to Datamart, and i was wandering if i create a sql query within the datamart, am i able to use this query to create a report or i still need to create within the SQL enviroment. Basically, i brought in a table, writing a sql query and would like to use the query to create the report.

Hi what i mean is i have the table in powerbi, if i right a query for that table in sql, the new query i have created. how can i use it for the report. Normally i would do the query in sql management then bring the query in PowerBI to create the report. with the datamart now lettting us write query in sql. i was just wandering if i can use that query against a report.

"Basically, i brought in a table, writing a sql query and would like to use the query to create the report." OK, so what's the problem? If you've brought in a table into PBI Desktop or Online, then what keeps you from using it to create reports?

I've never heard about anyone being able to run a SQL query against a report created in Power BI... SQL is for querying databases. DAX is for querying semantic models. Two very different things.

HI thanks for your reply. Here's an example of what i am trying to do. Actual ScenarioSQL Management - Table - InventoryAs an example, i have a table in MS SQl - i would write a sql query to clean my data and only bring or have want i need to create a report. Once Completed. Within Power BI i would connect to SQL and input my sql query i have created. Then create the dashboard. Scenario 2 Datamart - SQL Editor Here i connected to a ODATA connection. i have imported some table, once imported, using the slq editor, i would create a query the same way i did via the SQL Management. Once i am done with the query, am i able to use this query to create a dashboard.

Sorry forgot to ask. If i can't do this, what is the need or purpose of having a sql editor in Datamart. Also if not mistaken, with the ODATA file i would have imported the data in the datamart, i would be able to connect to a the SQL management by copying the code provided from the datamart and then i would suppose i would be able to write a sql query, then use that query for the dashboard in power bi. Does this make sense.

Datamart - SQL query Editor | Microsoft Fabric Community

12 Replies

daXtreme
Solution Sage
3 years ago
"Basically, i brought in a table, writing a sql query and would like to use the query to create the report."

OK, so what's the problem? If you've brought in a table into PBI Desktop or Online, then what keeps you from using it to create reports?
- KevinMorneault
  Helper II
  3 years ago
  Hi what i mean is i have the table in powerbi, if i right a query for that table in sql, the new query i have created. how can i use it for the report. Normally i would do the query in sql management then bring the query in PowerBI to create the report. with the datamart now lettting us write query in sql. i was just wandering if i can use that query against a report.
  - daXtreme
    Solution Sage
    3 years ago
    I've never heard about anyone being able to run a SQL query against a report created in Power BI... SQL is for querying databases. DAX is for querying semantic models. Two very different things.
CharleyKirton
Frequent Visitor
3 years ago
KevinMorneault - did you ever find out the answer? I came looking for that exact thing. I don't see the point in writing the SQL to make a new query if you can't access that query result from the PBI report. 🤔
nabullock
Frequent Visitor
3 years ago
Did anyone evere answer this?
I have loaded tables into a datamart, then wrote a SQL query on those tables. It runs and I can see results, but the query does not show up in the report writer, only the tables do.
- CharleyKirton
  Frequent Visitor
  3 years ago
  Yeah, same nabullock . Maybe it's only like this while it's in preview and they bring the access to the SQL queries into the report layer, otherwise it seems quite pointless - certainly for the way we work in my office.
  - nabullock
    Frequent Visitor
    3 years ago
    I ended up using the SQL quries as data sources within the Power BI dataset

Forum Discussion

Datamart - SQL query Editor

12 Replies

Related content

power query editor slow loading

Datamart future

Abnormal data display in Query Editor

Datamarts in Fabric

Power Query Editor