Power BI
  • 5 Minutes to read
  • Dark
    Light

Power BI

  • Dark
    Light

Article Summary

Prerequisites

  • You already have PowerBI.
  • You already created at least one source.

Creat a New Data Flow to Power BI

In Dataddo

  1. Navigate to 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.
    NOTE

    You can add more than one source with the schemas to the same flow or blend data.

  3. Once you select your data source, click on Add Destination, followed by navigating to the Dashboarding Apps tab and selecting PowerBI.
  4. Name your flow by typing the name into the top and check your Data Preview to make sure your configuration is without a problem.
  5. Click on Save flow.
    Vertica- Flow 4

In Power BI

  1. After saving your flow in Dataddo, a window with configuration details will appear. You can check this information again by clicking on power plug button with Connection Details.
  2. You will be presented with two options: Power BI Personal Dashboard and Power BI Shared Dashboard.
    NOTE

    Choose the Power BI Shared Dashboard option if you plan to share your PowerBI report or dashboard via the PowerBI Online Service

Configuring the Connection for a Personal Dashboard

  1. Make sure you have admin rights on your Windows device, if not, please configure connection for shared dashboard.
  2. In the configuration window, navigate to the PowerBI Personal Dashboard tab and click on download the installer depending on your Windows version.
  3. Extract the content of the downloaded zip file and look for the Installer file.
  4. After opening the Installer file, click on More Info and Run anyway.
  5. The terminal window will appear when the installation runs. Press enter to exit. The connector is now installed on your computer.
  6. Open Power BI and click on Get data from another source.
  7. Choose Dataddo (Beta) from the list of apps and click on Connect.
  8. Insert the API key from Dataddo (your flow's connetion details window) and click on Connect again.

Configuring the Connection for a Shared Dashboard

  1. Open your Power BI desktop and
  2. Click on "Get data" and select "Web".
  3. Click on "Advanced".
  4. Copy & paste theURL Path from the configuration window in Dataddo. The value is in a https://api.dataddo.com/v1.0/get/aaaaaaaaaaaaaaaa0201b4f3?type=csv format
  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 continue with the setup for report sharing below.

Sharing Report via Power BI Online Service

  1. Make sure that you configured the connection between Dataddo and PowerBI using 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 accurate and fresh data.
    You can do that through the My workspace window,
    Power BI - Schedule Refresh 1
    or click on Schedule refresh on the left side of the Power BI website.
    Power BI - Schedule Refresh 2

  3. At first, you will get an error message stating that the credentials are invalid. Go to Datasets Settings page and in Data source credentials click on Edit credentials.
    Power BI - Schedule Refresh 3

  4. Check the Skip test connection (other fields can stay unchanged) as it causes for the error message to pop up.
    Power BI - Configure Dataddo data set

  5. Once this is done, click on Sign in and set up the refresh frequency in the Scheduled refresh section. The next refresh will work without any problem.
    Power BI - Settings for Dataddo data set


Limitations

There's a limit to how much data you can send to Power BI at once. Check the number of your rows by previewing your data. Click on the three dots next to your source or flow and select Data Preview.

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 1 million rows, Power BI will return an error and the query fails. Your underlying data can still contain more than 1 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 limit per user: The maximum number of data sources allowed per user is 1 000. This limit applies to Power BI service only.

Specific features will have their own limitations.

How to Avoid Limitations?

There are two ways to avoid the above-mentioned limitations.

  1. Limit the amount of data. It is also possible the amount is too large due to incorrectly configured snapshotting settings.

  2. Connect the data to a data warehouse first, and then to Power Bi. Use a database like Google Sheets., or opt for a data warehouse for more of a long-term solution, e.g. Azure Blob Storage..

Troubleshooting

Unable to Install the Dataddo Power BI Plugin

In case your device does not allow you to install the Dataddo Power BI plugin, proceed configuring a connection for a shared dashboard instead. As no installation is needed, this method is guaranteed to work.

Cannot Refresh or Connect Data

If an error message regarding a failed update of the data source pops up, go back to configuration to check the Skip test connection box, and continue to sign in.

Power BI - troubleshooting

Power BI Unexpected Line Breaks

In some cases, your data in Power BI might be pushed into another column instead of simply showing null value. This happens when your data contains, for example, descriptions or other written content which is why some characters can be then interpreted as line breaks by Power BI.

To avoid this, when connecting Dataddo to Power BI, choose Ignore quoted line breaks for line breaks.

Power BI - Comma-Separated Values - step 2


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?

What's Next