How to Connect Power BI
  • 6 Minutes to read
  • Dark
    Light

How to Connect Power BI

  • Dark
    Light

Prerequisites

  • You already have a PowerBI.
  • You already created at least one Source.

Creating a New Data Flow to Power BI

In Dataddo

  1. Click on Flows at the top of the page and proceed with Create Flow in the top right corner .
  2. Click on Add Source and choose the source you'd like to include in the flow. You can type the source or connector's name into the search bar to find it faster. You can add more sources or blend two sources in the same flow. Read more about Data Blending here.
  3. Once you select your data source, click on Add Destination, followed by navigating to Dashboarding Apps and selecting PowerBI.
  4. You can Name your flow by typing the name into the top.
  5. You can see a Data Preview to make sure of your configuration.
  6. Click on Save flow.

Vertica- Flow 4

In Power BI

  1. After saving flow in Dataddo, the configuration window will appear. If not, or you already closed it, click on the three dots next to the flow and choose Config.
  2. You will be presented with two options. Power BI Personal Dashboard and Power BI Shared Dashboard.
    1. Use PowerBI Personal Dashboard when you do not plan to share your PowerBI Report / Dashboard with your coworkers via PowerBI Online Service.
    2. Use PowerBI Shared Dashboard when you plan to share your PowerBI Report / Dashboard with your coworkers via PowerBI Online Service.

Configuring the connection for shared dashboard

  1. Open your Power BI desktop.
  2. Click on "Get data" and select "Web".
  3. Click on "Advanced".
  4. Copy & paste the value of URL Path from the configuration window in Dataddo. The value is in a format of https://api.dataddo.com/v1.0/get/aaaaaaaaaaaaaaaa0201b4f3?type=csv
  5. In the HTTP Request Parameters type Authorization to what appears as select box.
  6. Copy & paste the value of the authorization header. The value is in a format of Bearer aaaaaaaaaaaaaaaa744609253455d7ec3081e84c708e4d93a16548275382da40.
  7. If you want to share your report with others, please follow with the setup for report sharing.

Configuring the connection for personal dashboard

  1. Make sure you have the admin rights on your Windows machine, if not, please use Configuring the connection for shared dashboard.
  2. In the configuration window click on download the installer. Choose x64 or x86 depending on the system you use. To find out, if you have Windows 64-Bit or 32-Bit click here.
  3. 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).
  4. Open the unpacked folder and look for the Installer file. Right-click on the file and Open.
  5. Click More Info and then Run anyway.
  6. The terminal window will appear when the installation runs. Press enter to exit. The connector is now installed on your computer.
  7. Open Power BI and click on Get data from another source.
  8. Choose Dataddo (Beta) from the list of apps and click on Connect.
  9. 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.

Sharing report 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. Make sure that you configured the connection between Dataddo and PowerBI using Configuring the connection for shared dashboard guide. Sharing of the dashboard will not work if you are connecting via installed desktop plugin.
  2. 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

  1. 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

  2. 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

  3. 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

Troubleshooting

Cannot install Dataddo Power BI plugin

In case you are struggling with the installation of Dataddo Power BI plugin from whatever reason (e.g. you do not have Windows admin rights for your computer), please use configuration of the connection for shared dashboard. This does not require any installation and will work always.

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

Limitations

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.

Need assistance?

Feel free to contact us and we will help you with the setup. To speed the process of resolving your issue, make sure you provide us with sufficient information.


Was this article helpful?