Skip to main content

    Power BI

    Needs Votes

    Data Catalog integration in PowerBI Designer

    Vote (860) Share
    Ron Pooters's profile image

    Ron Pooters on 20 Dec 2014 03:25:40

    The PowerBI Designer is missing integration with the Data Catalog and there is no online search functionality. The data catalog is a core component of the reporting solution so let me use it with the Power BI Designer

    Administrator on 20 Aug 2020 01:24:05

    Checking w/ the team where this is at.

    Comments (65)
    Ron Pooters's profile image Profile Picture

    a8e24f53 559a-4a96-97b6-d6138fad0297 on 16 Aug 2020 04:05:57

    RE: Data Catalog integration in PowerBI Designer

    Hi there
    Can you please let me know if we have a resolution on this? Currently just copy and paste from the Advance editor is the quickest option but being able to share the queries with others in the company would be more than "handy". Cheers

    Ron Pooters's profile image Profile Picture

    973f12ed 31c3-4785-a11e-1aa112671a13 on 16 Aug 2020 04:02:01

    RE: Data Catalog integration in PowerBI Designer

    Any progress?

    Ron Pooters's profile image Profile Picture

    6dbb2c0a 607c-4728-bc2b-53ff4b5ad044 on 16 Aug 2020 04:01:27

    RE: Data Catalog integration in PowerBI Designer

    Any official Microsoft response to this? Is it on your Roadmap? If yes, is there an ETA? Thanks!

    Ron Pooters's profile image Profile Picture

    ebde5095 f33e-4b02-a8fb-54cd03cfaf48 on 16 Aug 2020 04:01:15

    RE: Data Catalog integration in PowerBI Designer

    I just came back to this same issue after posting an initial comment 2 years ago to find that a user friendly solution to this fundamental daftness still hasn't been implemented by Microsoft. So we're off to find another non-MS product that will deliver, which is a shame as PQ and PBI are both good products (independently of themselves!)

    Ron Pooters's profile image Profile Picture

    632265ac eddf-47ab-92f5-38ff7a21ffec on 16 Aug 2020 04:01:13

    RE: Data Catalog integration in PowerBI Designer

    PBI should support consuming queries from data catalog, the underlying M language source code is identical!

    Ron Pooters's profile image Profile Picture

    fcb25184 91ca-ea11-a812-000d3a8ddfb2 on 16 Aug 2020 04:00:58

    RE: Data Catalog integration in PowerBI Designer

    Hi Chuck - any updates on where the team is with this?

    Ron Pooters's profile image Profile Picture

    bc0603d8 3339-4354-a26b-c5addaa6e623 on 16 Aug 2020 04:00:12

    RE: Data Catalog integration in PowerBI Designer

    '@Fred Kaffenberger That works, wow! But quite complicated and not the preferred way for standard users.

    Ron Pooters's profile image Profile Picture

    3e21bf9b ebd0-ea11-a812-000d3a579c39 on 16 Aug 2020 03:59:23

    RE: Data Catalog integration in PowerBI Designer

    To use a shared query in Power BI currently, you have to open Excel, Data tab on the ribbon, Get Data, Data Catalog Search, Load a Query (likely connection only); edit the workbook query, pop out the query list, right click, copy. Then go to Power BI, edit queries, and paste. Then, repeat every time you want to use a shared query.

    Ron Pooters's profile image Profile Picture

    0ed41e5b b202-e711-8103-5065f38a2b21 on 16 Aug 2020 03:59:09

    RE: Data Catalog integration in PowerBI Designer

    In order to completely deportment Power BI and enable users to be self-service having a data Catalog is a must.

    Ron Pooters's profile image Profile Picture

    9230ac82 2062-ea11-a811-000d3a579c35 on 16 Aug 2020 03:59:08

    RE: Data Catalog integration in PowerBI Designer

    Can we have an update please? This feature is desperately needed.