Try our plataform
Power BI Via Kondado Connection

Use your table's Link to create the Power BI Via Kondado connection

Power BI steps

  1.  Open Power BI and click on Blank Report:

    1.  
  2. In the Home tab, click on Get Data:

    1.  
  3. In the data source selection, choose the Web option and click Connect:

    1.  
  4.  Now you will need to enter the URL of your data and click OK (learn how to get the URL here):

    1.  
  5. After entering the URL, Power BI will display a portion of the table so you can ensure that the data types are correct. If it is, click on the Transform data option. Power BI will then load your data:

    1.  
  6. Repeat those steps for each Kondado table you want to add to Power BI.

Kondado steps

  1.  Don't know the URL Link of your data? Follow this mini tutorial to learn where to get it (you can also learn it here)
     
  2. After finishing our onboarding , you will have created your data destination, data source, and pipelines. So, head back to our platform and click on the PIPELINES menu:

    1.  
  3. You will see a list of your pipelines. Select the pipeline you want to add to Power BI:


    1.  
  4. Upon entering the pipeline, look for and click on the “Visualize Data” button, as shown in the image below;


    1.  
  5. In the next window, first, select the decimal separator option (comma or dot), then find which table you want to add to Power BI and click the button to copy the URL next to it:


    1.  
  6. Now you can paste the Link on 4thstep of the tutorial.
     

Authentication for “Access web content”

The data authentication screen in Power BI appears on several occasions, depending on the type of data connection or service used. When creating a report in Power BI and/or editing our model, the window below may appear:

If this happens, simply select the "Anonymous" tab, then click on "Connect" .

Scheduling Automatic Updates in Power BI Online

After loading data into a Power BI template dashboard from Kondado and publishing it to Power BI Online, you may encounter an error when trying to schedule automatic data updates. One of the most common errors is:

- Data source error: "Information is needed in order to combine data. Please specify a privacy level for each data source. Information about a data source is required. The exception was raised by the IDbCommand interface. Table: (table name)."

- This error happens due to a mismatch in credentials between the “.pbix” file you used to publish your dashboard and the file available in Power BI Online.

- To avoid or resolve this error, follow these simple steps:
 

  1. Verify Database Credentials
    1. Before publishing your dashboard, ensure that the database credentials are correct by following these steps:
       
    2. In Power BI Desktop, go to the “Home” tab and click on Transform Data:
       


    3.  
  2. Configure Data Source
    1. Now, click on Data source settings in the "Home" menu:
       

    2.  
  3. In the window that appears, select each data source individually and click Edit Permissions:



    1.  
  4. Set the "Privacy Level" to Public:


    1.  
  5. Publish the Dashboard
    1. Return to your dashboard and click Publish to send your dashboard to Power BI Online:
       


    2.  
  6. Configure Credentials in Power BI Online
    1.  In Power BI Online, go to the Scheduled Refresh settings for your dataset:
       

    2.  
  7. On the page that appears, in the Data source credentials section, click Edit credentials for each data source:


    1.  

       
  8.  Adjust Authentication Method
     
  9.  In "Authentication Method," select Anonymous.
     
  10. In "Privacy level settings for this data source," choose Public and click Sign in:


    1.  
  11. That's it! Now your credentials are properly configured, and you will be able to schedule automatic updates for your dataset without errors.