St. Louis Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Power Query and Power BI

  • 1.  Power Query and Power BI

    Posted Nov 29, 2018 09:02 AM
    My internal customer has me building queries that I am uploading to "My Data Catalog Queries" from Excel 2010 (we may get 365 next year).

    Once I make the query available; my customer can use it in any spreadsheet he wants.

      When I go over to Power BI, are these queries discoverable? Or is this Microsoft slapping the name on everything?

    I really like this catalog; beats having to build bunch of connection strings to SQL Server and copying them to customer machine.

    The customer is linking the spreadsheet to Power BI but it seems counter-productive to me.

    Thanks!

    ------------------------------
    Alan Barasch
    Developer
    St Louis
    ------------------------------


  • 2.  RE: Power Query and Power BI

    Silver Contributor
    Posted Nov 30, 2018 08:57 AM
    Data Catalog's was a neat idea but one that is about to stop working very shortly here. Hopefully they revisit this in the future and fully integrate it into Power BI. I was kind of curious as I hadn't seen it anywhere on the O365 ribbon (Fast Insider) and they buried it pretty deep, honestly at this point I couldn't even sign into my own personal tenant's catalog.


    Important: Data Catalog Deprecation Notice
    Data Catalog capabilities in Excel and Power Query will stop working on March 4th, 2019. Users will be able to consume content already published to the Data Catalog until that date. However, starting on December 3rd, 2018, users will not be able to publish (share) new or updated queries into the Data Catalog. We recommend you download your shared queries so you can continue using them outside the Data Catalog beyond March 4th, 2019. You can download the full definition of your queries from the My Data Catalog Queries task pane, using the Open option for each of the queries.

    Getting Started with Power Query
    Office remove preview
    Getting Started with Power Query
    Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016. Important: Data Catalog Deprecation Notice Data Catalog capabilities in Excel and Power Query will stop working on March 4th, 2019.
    View this on Office >


    ------------------------------
    Alex Powers
    It's Not About The Cell
    Saint Louis MO
    8157182707
    ------------------------------



  • 3.  RE: Power Query and Power BI

    Bronze Contributor
    Posted Nov 30, 2018 09:41 AM
    Hey Alan!
    I'm not super familiar with the Data Catalog functionality, so I decided to test it out a little within my own environment and research it a bit.  We are currently in Office 365, so I wanted to see if I was able to upload to the data catalog.  Interestingly enough, I wasn't able to authenticate using the Send to Data Catalog function, which led me to dig into things a bit further.

    Based on what I found, it appears that Data Catalog as was known is being deprecated; partially as soon as December 3, 2018:

    Getting Started with Power Query

    In usual Microsoft fashion, the deprecation is clear as mud; as Azure has a Data Catalog offering that would seem to incline me to believe it was still continuing, but upon further review, you can see the lack of integration between tools such as Excel and the Azure Data Catalog:

    Get started with Azure Data Catalog

    It looks like the catalog is managed through Azure now, and there's no interface from your local applications to the catalog.  Now, instead of discovering the sources from your client application, you download the connections that you want based on the level of access you have to the catalog.  It looks like multiple apps are accessible from the Data Catalog Portal:

    Hope that helps.  Let me know if I missed the mark on your question.  ;-)

    ------------------------------
    Chase Marler
    Database Administrator
    ------------------------------



  • 4.  RE: Power Query and Power BI

    Silver Contributor
    Posted Nov 30, 2018 01:37 PM
    Great find @Chase Marler ! Unfortunately, my wrist started to give out from the incredible amount of scrolling on that page haha! Getting non-power users who simply want to "get-it-done" into this environment seems like it could be a challenge in and of itself.

    Here's hoping to something more friendly in the future.

    ------------------------------
    Alex Powers
    It's Not About The Cell
    Saint Louis MO
    8157182707
    ------------------------------