How Can I Update the Data Source in Power BI?

The features described in this article are only available to customers with iClassPro subscription plans that provide access to the Data Warehouse.

IN THIS ARTICLE:
Learn more about how to update the Data Source being referenced by your Power BI template.

Occasionally, it may be necessary to update the address of the Data Source being referenced by your Power BI template.  To do this:

  1. After loading your template, click Home in the toolbar at the top of the screen.
  2. In the Queries section of the toolbar, choose Transform Data to open the “Power Query Editor” window.
    power_bi_query_editor.png
  3. In the Queries panel on the left-hand side, click Families.
  4. In the Query Settings panel (right-hand side), click Source in the APPLIED STEPS section.
  5. Click on the down arrow to expand the formula bar.
  6. Edit the query to replace the value in the first set of quotations with the new Data Source URL.
  7. Click the Edit Credentials button below this query, then enter the saved credentials that have been sent securely to you.
  8. Repeat steps 3 through 6 to edit the Source for all of the queries in the Queries panel (with the exception of “Date Query” and “Dates”).
  9. Once you have made the changes, be sure to Close & Apply your changes.

 

Need more assistance?

Customer support is available at 1-877-554-6776 Mon - Fri, 9 am to 9 pm (CT) and Sat, 9 am to 6 pm (CT).