Open Forum

 View Only

View My Drafts

  • 1.  Power BI examples not working with SL2018

    Posted Feb 25, 2022 04:38 PM
    We are having problem with the QQ_ views.  All of the views Power Bi examples are looking at do not exist.  Is there a setup step missing?  I noticed there was one for SL 2015 CU2 but I wasn't able to find one for SL2018.

    ------------------------------
    Michael Coman
    AccuNet Inc.
    Westerville OH
    ------------------------------


  • 2.  RE: Power BI examples not working with SL2018

    TOP CONTRIBUTOR
    Posted Feb 25, 2022 06:14 PM
    Try running this is the system database:

    CREATE PROCEDURE dbo.QVCatalog_Entries
AS
	Select DISTINCT SQLView from QVCatalog where module <> 'SY' order by SQLView​


    They neglect to create that when Dynamics SL is updated from an earlier version.



    ------------------------------
    Jonathan Van Houtte
    Architect
    XLstatements, LLC
    Clifton Park NY
    ------------------------------

    Original Message


  • 3.  RE: Power BI examples not working with SL2018

    Posted Feb 27, 2022 10:41 AM
    Thank you Jonathan.  When I ran that statement it did not create the views.  This client did not use Power BI before the upgrade.  They are just getting started.

    ------------------------------
    Michael Coman
    AccuNet Inc.
    Westerville OH
    ------------------------------

    Original Message