How to connect data to Power BI via Dataslayer API
Using the Dataslayer API Query Manager product, you can easily create queries and connect your data from various data sources to Power BI. Once you've started, you can schedule refreshes for your data in Power BI.
Building a query in API Query Manager
Log in via our website.
Select "Start trial" on the API product or click on the "Dataslayer API" link at the top.
Click on "New query" to create your URL.
Authenticate the data source you prefer and build the query you need.
Write a query name to identify your URL.
Select the "Power BI" format and the timezone you want.
Copy the "Short URL" or the Standard one.
(Optional) Preview your data on the "View data" button.
Inserting our data in Power BI
Open Power BI.
Click on "Get data" on the top menu and select "WEB".
A pop-up window will appear. Copy-paste there the URL you copied before from our API Query Manager product.
Wait for the data to load. Then you will be able to select the table you have just imported and transform the data if you want.
And that's all! This is the best way to import any of your digital marketing data into Power BI. What a wonderful tool, right?
As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!
Updated on: 20/10/2022