Forum Discussion
Datamart - SQL query Editor
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. ...
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.
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.
I ended up using the SQL quries as data sources within the Power BI dataset
