How to Connect Power BI

The new Power BI connector provides a seamless connection between Dataddo and Power BI, resulting in automatic syncing of your Data Sources with all of your Data Flows available instantly in your dashboard.

Warning: This connector must be configured with the Power BI Desktop version.

Navigation

Troubleshooting

How to connect Power BI with the new Dataddo App

How to setup Power Bi connector without downloading a file

Comma-Separated Values lining Issue

Where can you find the Dataddo API key for Power BI?

Additional Information


Troubleshooting

Cannot Refresh / Connect Data

If you see an error message regarding a failed update of the data source, as per below, check the box Skip test connection and continue to sign in.

Power BI - troubleshooting

Limit of Data Records

When sending your data to Power BI, be aware that it has a limit of how much data it can connect at once. You can see how much data is in the source by clicking Data Preview (three dots next to the source under Sources) and the total number of records is shown in the top left.

There are other limitations that apply to specific features, but the following list applies to the full Power BI service:

  • Dataset size limit - There's a 1-GB limit for datasets stored in Shared capacities in the Power BI service. If you need larger datasets, you can use Power BI Premium.
  • Distinct values in a column - When caching data in a Power BI dataset (sometimes called 'Import' mode), there is a 1,999,999,997 limit on the number of distinct values that can be stored in a column.
  • Row limit - When using DirectQuery, Power BI imposes a limit on the query results that are sent to your underlying data source. If the query sent to the data source returns more than one million rows, you see an error and the query fails. Your underlying data can still contain more than one million rows. You're unlikely to run into this limit as most reports aggregate the data into smaller sets of results.
  • Column limit - The maximum number of columns allowed in a dataset, across all tables in the dataset, is 16,000 columns. This limit applies to the Power BI service and to datasets used in Power BI Desktop. Power BI tracks the number of columns and tables in the dataset in this way, which means the maximum number of columns is 16,000 minus one for each table in the dataset.
  • Data source user limit - The maximum number of data sources allowed per user is 1000. This limit applies to Power BI service only.

The solution:

  1. You can either limit the amount of data (it is possible the amount is this huge because of incorrect snapshotting settings)
  2. Or connect the data to a data warehouse instead and then to Power Bi. One option is to use a database, e.g.  Google Sheets, or you can start using a warehouse for more of a long-term solution, e.g. Azure Blob Storage.

How to Connect Power BI with Dataddo 

STEP 1 - Create New Data Flow

  1. Sign in to your Dataddo account and click on Flows at the top of the page. 
  2. Click on Create Flow in the top right corner.
  3. Click on Add Source to connect it to the destination. You can type the connector's name into the search bar to find it faster.
  4. Click on Add Destination. 
  5. Go to the Dashboarding Apps tab and select Power BI from the list.
    Power BI in app - step 4
  6. Click on Save Flow.
  7. Click on Show Configuration in the pop up window to continue the installation.

    Power BI in app - step 5

  8. Go to Power BI Desktop tab and click on download the installer. Choose x64 or x86 depending on the system you use.
    NOTE: Find out, if you have Windows 64-Bit or 32-Bit here.

    Power BI in app - step 6

  9. Copy the Dataddo API key, you will need it later.

STEP 2 - Install Dataddo in Power BI

  1. Download the x64 or x86 installer.

    NOTE: Make sure Power BI Desktop is installed on the device

  2. A zipped file will be downloaded to your computer. Unpack the folder (meaning, copy + paste the folder somewhere outside the zipped folder, like onto your desktop).
  3. Open the unpacked folder and look for the ‘Installer’ file. Right-click on the file and Open.
  4. Click More Info and then Run anyway.
    Power BI desktop - step 4
  5. The terminal window will appear when the installation runs. Press enter to exit. The connector is now installed on your computer.
    Power BI desktop - step 5
  6. Open Power BI and click on Get data from another source.

    Power BI desktop - step 1

  7. Choose Dataddo (Beta) from the list of apps and click on Connect.

    Power BI desktop - step 2

  8. Insert the API key from Dataddo and click on Connect again. 
    If you cannot find the API key, you can find it in the Flow section. Check the instructions below.

    Power BI desktop - step 3

  9. Congratulations! Now you can choose any Data Flow from Dataddo, preview the data, and configure it within Power BI.

 



Additional Information

Sharing your report and datasets with coworkers via Power BI online service

If you want to share your report and all the underlying data sets with your coworkers using the Power BI online service, you can simply do that by sharing your report.

  1. You will need to schedule an automatic refresh so that your coworkers have the correct and newest data.
    1. One option is to go to My workspace window,
      Power BI - Schedule Refresh 1
    2. The second option is to click on Schedule refresh on the left side of the Power BI website.
      Power BI - Schedule Refresh 2
  2. At first, you will get an error message stating that the credentials are invalid. You need to go to the Datasets' settings page and in Data source credentials click on Edit credentials.
    Power BI - Schedule Refresh 3
  3. You can keep all the fields as they are, but you need to select Skip test connection. We want Power BI to skip this test as this is causing the problem.
    Power BI - Configure Dataddo data set
  4. Once this is done, we can click on Sign in and set up the scheduled refresh in the Scheduled refresh part as wanted. The next refresh will work without any problem.
    Power BI - Settings for Dataddo data set
 

Need assistance?

Feel free to contact us or create a ticket and we will help you with the setup. To speed the process of your ticket is resolved, make sure you provide us with sufficient information.