D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

View reports from LCS Shared Assets in Power BI Desktop

  • 1.  View reports from LCS Shared Assets in Power BI Desktop

    Posted 12 days ago
    Where can I get the SQL Server credentials for opening a .pbix files from LCS Shared Assets? The database is AXDW.

    ------------------------------
    Jack Ogle
    DFW Heavy Duty
    Forth Worth TX
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: View reports from LCS Shared Assets in Power BI Desktop

    Posted 8 days ago
    If this is production, you do not have access to this database.
    If this is a Tier 1 or Tier 2 sandbox, the credentials are in LCS.  You can use the axdwruntimeuser account or axdwadmin account.  The server name and database name are in lcs.  Just add data.windows.net to the end of the database name.  The readonly user probably works as well but I haven't used that one. Don't know if this image will be readable for you or not but this is all under database accounts in the LCS details page for the environment.


    ------------------------------
    Laura Jacobowitz
    Sr. Solution Architect
    AXtegrity Consulting
    Hilton Head Island FL
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: View reports from LCS Shared Assets in Power BI Desktop

    Posted 5 days ago
    Thanks Laura. So on the SQL Server database pop-up I'm selecting the Database option on the left, then entering the axdwadmin username/password from LCS for our UAT sandbox. Below the credentials fields it has "Select which level to apply these settings to" with a dropdown of "localhost" and "localhost;AXDW". That returns several errors when trying to connect, "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible." Where/how do I add data.windows.net to the end of the db name?

    ------------------------------
    Jack Ogle
    DFW Heavy Duty
    Forth Worth TX
    ------------------------------

    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role