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

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


How to connect Power BI with Dataddo 

STEP 1 - Create new Data Flow in Dataddo

   
Number 1

Sign in to your Dataddo account and click on Flows at the top of the page.

Home Page - Data Flow

Number 2

Click on Create Flow in the top right corner.

My Flows - Create Flow

Number 3

Choose the Data Source you want to connect to Power BI by clicking on Add Source.

Number 4

Click on Add Destination. 

Power BI in app - step 3

Number 6

Go to the Dashboarding Apps tab and select Power BI from the list.

Power BI in app - step 4

Number 7

Click on Save Flow.

Number 8

Click on Show Configuration in the pop up window to continue the installation.

Power BI in app - step 5

Number 9

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

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

STEP 2 - Install Dataddo in Power BI

   
Number 1

Run the installer and follow the steps accordingly.

Number 2

Open Power BI and click on Get data from another source.

Power BI desktop - step 1

Number 3

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

Power BI desktop - step 2

Number 4

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

Power BI desktop - step 3

Number 5

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

 


If you are unable to download or run the installer due to Antivirus, Firewall, or your company policy, follow the steps below.

How to setup Power Bi connector without downloading a file

If you closed Dataddo without copying the API key, you can access it anytime:

   
Number 1

Open Power BI and click on Get data from another source.

Power BI desktop - step 1

Number 2

Search and navigate to the Web source and select Advanced.

PowerBi setting up the data

Number 3

Go back to the Dataddo app. In Flows, click on the three dots Three dots on the right next to the flow you want to connect and select Configure endpoint.

Power BI browser - step 1

Number 4

Go to Power BI tab and copy the URL path.
Power BI browser - step 4

Number 5

Go back to Power BI and insert the copied link into the URL parts.
Power BI browser - step 5

Number 6

One more copy-paste. Go back to Dataddo again, and copy the HTTP Request Value.
Power BI browser - step 6

Number 7

In Power BI , go the HTTP request section and type the value Authorization.
Power BI browser - step 7

Number 8

Now, paste the copied value into the second column of the HTTP Authorization and click on OK.
Power BI browser - step 8

Number 9

Once you click on OK, a preview of the data will appear. If everything looks correct, then you can finalize the configuration by clicking on the Load.
Power BI browser - step 9

 

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


Comma-Separated Values lining Issue

If your data is not showing properly in your Power BI table, the problem might be in the formatting of the CSV file that is sent to your Power BI from Dataddo.

To fix this issue, see the quick guide below:

   
Number 1

Edit your source in Power BI by clicking on the gear icon next to the Source step and go to Advanced.
Power BI - Comma-Separated Values - step 1

Number 2

Change the Line breaks setting to Ignore Quoted Line Breaks.

Power BI - Comma-Separated Values - step 2

 


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

If you closed Dataddo without copying the API key, you can access it anytime:

   
Number 1

Go to the Flow section in Dataddo.

Number 2 Click on the three dots Three dots on the right next to the flow you want to connect.
Number 3 Select Configure endpoint.
Number 4 Go to the Power BI Desktop tab and copy the API key.
Number 5 In Power BI, paste the API key and connect.

 


Additional Information

Sharing your report and data set 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.

   
Number 1

You will need to schedule an automatic refresh so that your coworkers have the correct and newest data.

a)

One option is to go to My workspace window,
Power BI - Schedule Refresh 1

b)

The second option is to click on Schedule refresh on the left side of the Power BI website.
Power BI - Schedule Refresh 2

Number 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
Number 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
Number 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