--- title: How to connect data to Power BI via Dataslayer API description: 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. --- [Skip to content](https://support.dataslayer.ai/how-to-connect-data-to-power-bi-via-dataslayer-api#main-content) - [English](https://support.dataslayer.ai/how-to-connect-data-to-power-bi-via-dataslayer-api) - [Español](https://support.dataslayer.ai/es/cómo-conectar-datos-a-power-bi-con-la-api-de-dataslayer) English Show submenu for translations [![Dataslayer](https://support.dataslayer.ai/hs-fs/hubfs/Dataslayer_New_Logo.png?height=35&name=Dataslayer_New_Logo.png)](https://www.dataslayer.ai/) Open main navigation Close main navigation - - [English](https://support.dataslayer.ai/how-to-connect-data-to-power-bi-via-dataslayer-api) - [Español](https://support.dataslayer.ai/es/cómo-conectar-datos-a-power-bi-con-la-api-de-dataslayer) English Show submenu for translations Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge base](https://support.dataslayer.ai/?hsLang=en) 2. [API Query Manager](https://support.dataslayer.ai/api-query-manager?hsLang=en) July 17, 2024 # 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. Remember that you also have our **Power BI destination**. Find out more at [this link](https://dataslayer.ai/power-bi).  ![faqs (23)](https://support.dataslayer.ai/hs-fs/hubfs/faqs%20(23).png?width=688&height=61&name=faqs%20(23).png) 1\. [Log in](https://app.dataslayer.ai/login) via our website. ![creatividades-faq-bq-features\_bwlgn3 (1)](https://support.dataslayer.ai/hs-fs/hubfs/creatividades-faq-bq-features_bwlgn3%20(1).png?width=688&height=267&name=creatividades-faq-bq-features_bwlgn3%20(1).png) 2\. Select "Start trial" on the API product or click on the ["Dataslayer API"](https://app.dataslayer.ai/query-manager) link at the top. 3\. Click on "New query" to create your URL. 4\. Authenticate the data source you prefer and build the query you need. ![captura-de-pantalla-2022-10-20\_1osblcs](https://support.dataslayer.ai/hs-fs/hubfs/captura-de-pantalla-2022-10-20_1osblcs.png?width=688&height=894&name=captura-de-pantalla-2022-10-20_1osblcs.png) 5\. Write a query name to identify your URL. ![captura-de-pantalla-2022-10-20\_1ggrvnw](https://support.dataslayer.ai/hs-fs/hubfs/captura-de-pantalla-2022-10-20_1ggrvnw.png?width=688&height=145&name=captura-de-pantalla-2022-10-20_1ggrvnw.png) 6\. Select the "Power BI" format and the timezone you want. ![captura-de-pantalla-2022-10-20\_1vxtkid](https://support.dataslayer.ai/hs-fs/hubfs/captura-de-pantalla-2022-10-20_1vxtkid.png?width=688&height=52&name=captura-de-pantalla-2022-10-20_1vxtkid.png) 7\. Copy the "Short URL" or the Standard one. ![captura-de-pantalla-2022-10-20\_e2yebs](https://support.dataslayer.ai/hs-fs/hubfs/captura-de-pantalla-2022-10-20_e2yebs.png?width=688&height=76&name=captura-de-pantalla-2022-10-20_e2yebs.png) 8\. (Optional) Preview your data on the "View data" button. ![captura-de-pantalla-2022-10-20\_1yy2jq3](https://support.dataslayer.ai/hs-fs/hubfs/captura-de-pantalla-2022-10-20_1yy2jq3.png?width=688&height=322&name=captura-de-pantalla-2022-10-20_1yy2jq3.png)   ![faqs (24)](https://support.dataslayer.ai/hs-fs/hubfs/faqs%20(24).png?width=688&height=61&name=faqs%20(24).png) 1\. Open Power BI. ![powerbi1\_1qf7fjt](https://support.dataslayer.ai/hs-fs/hubfs/powerbi1_1qf7fjt.png?width=688&height=387&name=powerbi1_1qf7fjt.png) 2\. Click on "Get data" on the top menu and select "WEB". ![powerbi2\_1takt6z (1)](https://support.dataslayer.ai/hs-fs/hubfs/powerbi2_1takt6z%20(1).png?width=688&height=440&name=powerbi2_1takt6z%20(1).png) 3\. A pop-up window will appear. **Copy-paste there the URL you copied before from our API Query Manager product.** **![powerbi4\_jz8lov](https://support.dataslayer.ai/hs-fs/hubfs/powerbi4_jz8lov.png?width=688&height=220&name=powerbi4_jz8lov.png)** 4\. 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. ![powerbi5\_94glq4](https://support.dataslayer.ai/hs-fs/hubfs/powerbi5_94glq4.png?width=688&height=387&name=powerbi5_94glq4.png) 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](https://dataslayer.ai/) chat or through our [email](mailto:info@dataslayer.ai) if you still have doubts or questions. We are happy to help!  - [General](https://support.dataslayer.ai/general?hsLang=en) - [Billing & Pricing](https://support.dataslayer.ai/billing-pricing?hsLang=en) - [Data Sources](https://support.dataslayer.ai/data-sources?hsLang=en) - [Blended Connectors](https://support.dataslayer.ai/blended-connectors?hsLang=en) - [Google Sheets](https://support.dataslayer.ai/google-sheets?hsLang=en) - [Microsoft Excel](https://support.dataslayer.ai/microsoft-excel?hsLang=en) - [Spreadsheets](https://support.dataslayer.ai/spreadsheets?hsLang=en) - [Looker Studio](https://support.dataslayer.ai/looker-studio?hsLang=en) - [Big Query](https://support.dataslayer.ai/big-query?hsLang=en) - [API Query Manager](https://support.dataslayer.ai/api-query-manager?hsLang=en) - [Power BI](https://support.dataslayer.ai/power-bi?hsLang=en) - [Amazon S3](https://support.dataslayer.ai/amazon-s3?hsLang=en) - [Amazon Redshift](https://support.dataslayer.ai/amazon-redshift?hsLang=en) - [Snowflake](https://support.dataslayer.ai/snowflake?hsLang=en#main-content) - [Marketplace](https://support.dataslayer.ai/snowflake?hsLang=en#marketplace) - [Google Cloud Storage](https://support.dataslayer.ai/google-cloud-storage?hsLang=en) - [Database](https://support.dataslayer.ai/database?hsLang=en) - [Azure SQL](https://support.dataslayer.ai/azure-sql?hsLang=en) - [Azure Storage](https://support.dataslayer.ai/azure-storage?hsLang=en) - [Dataslayer Atlas](https://support.dataslayer.ai/dataslayer-atlas?hsLang=en) - [Morpheus](https://support.dataslayer.ai/morpheus?hsLang=en) - [AI Looker Studio Analyzer](https://support.dataslayer.ai/ai-looker-studio-analyzer?hsLang=en) - [Dataslayer MCP](https://support.dataslayer.ai/dataslayer-mcp?hsLang=en) - [Dataslayer GPT](https://support.dataslayer.ai/dataslayer-gpt?hsLang=en) - [Dataslayer AI Chat](https://support.dataslayer.ai/dataslayer-ai-chat?hsLang=en) [![Chill listening crop-3](https://support.dataslayer.ai/hs-fs/hubfs/Dataslayer_New_Logo.png?width=142&height=24&name=Dataslayer_New_Logo.png "Chill listening crop-3")](https://dataslayer.ai/) Dataslayer.ai: Digital Marketing Reporting Made Easy Copyright © 2026, DATASLAYER SL