Forum Discussion

Josef2's avatar
Josef2
New Member
2 years ago

queries as basis for reports / Save query as a view

Dear all, is it possible to use SQL-queries as a basis for reports? We have prepared some which we would like to use similar to tables as basis for reports/visuals etc. Does anyone know how to do?...
Tips and Tricks
  • Josef2's avatar
    Josef2
    New Member
    2 years ago

    Hi Martin_D ,

    many thanks for your quick answer.

    What I did not mention is that we receive the data from Jira via PowerBI-Connector.
    We want to define some SQL queries ourselves and would like to know if there is a possibility to use the queries (their results) similar to the tables as basis for reports/visuals..?

     

    Many thanks in advance.

    kind rgds

    Josef

    • Martin_D's avatar
      Martin_D
      Icon for Solution Sage rankSolution Sage
      2 years ago

      Hi Josef2 ,

      The query language for Power BI data models is DAX, not SQL. You can express the same query in DAX. And you can load the result of this DAX query as a calculated table to the data model. Then the result of the query becomes part of the data model and you can use it in visuals.
      Here are a few ideas to get started with translating your SQL into DAX: From SQL to DAX: Joining Tables - SQLBI
      Kind regards,
      Martin