# PowerBI Connector how to get Domain **URL:** \ **Category:** Reports and working with data\ **Created:** [March 12, 2025, 10:20am UTC](https://community.piwik.pro/t/powerbi-connector-how-to-get-domain/4984 "2025-03-12T10:20:49Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Martin](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@Martin](https://community.piwik.pro/u/Martin)\ **Post date:** [March 12, 2025, 10:20am UTC](https://community.piwik.pro/t/powerbi-connector-how-to-get-domain/4984/1 "2025-03-12T10:20:49Z")
Hi all, I am trying to figure out how to pull the Page URL (domain) from either Raw data or the query using PowerBI connector. In Looker I have the dimension “Page domain” and it works fine. The PowerBI connector from Piwik really pisses me of. ---
**Author:** ![anthonybartczak](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/anthonybartczak/32/2430_2.png) [@anthonybartczak](https://community.piwik.pro/u/anthonybartczak)\ **Post date:** [March 12, 2025, 3:43pm UTC](https://community.piwik.pro/t/powerbi-connector-how-to-get-domain/4984/2 "2025-03-12T15:43:05Z")
Hi, I have passed this issue to the dev team. This dimension might need an additional transformation. I’ll get back to you. ---
**Author:** ![joao](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/joao/32/1820_2.png) [@joao](https://community.piwik.pro/u/joao)\ **Post date:** [March 18, 2025, 11:10am UTC](https://community.piwik.pro/t/powerbi-connector-how-to-get-domain/4984/3 "2025-03-18T11:10:22Z")
Hi @Martin, With the Raw data you have access to a few Page URL-related dimensions, for example: - Page URL [event\_url] - Session entry URL [session\_entry\_url] To extract the domain from these, you can simply add a new column using one of the following features: - [Column from examples](https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-add-column-from-example) - [Custom column](https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-add-custom-column) - Extract \> Text Between Delimiters @anthonybartczak Can we expect a Piwik PRO connector for Power BI Service any time soon? 🙏 ---
**Author:** ![Martin](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@Martin](https://community.piwik.pro/u/Martin)\ **Post date:** [March 18, 2025, 2:17pm UTC](https://community.piwik.pro/t/powerbi-connector-how-to-get-domain/4984/4 "2025-03-18T14:17:52Z")
Hi @joao , thanks for the tip.I already tried getting some usefull data with the raw data. But it takes forever to load due to the package load of the connector and raw data does not include ecommerce data. Would be great to have a connector that matches the LookerStudio one. Regards Martin ---
**Author:** ![joao](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/joao/32/1820_2.png) [@joao](https://community.piwik.pro/u/joao)\ **Post date:** [March 18, 2025, 2:38pm UTC](https://community.piwik.pro/t/powerbi-connector-how-to-get-domain/4984/5 "2025-03-18T14:38:26Z")
Yes, the Power BI connector is very slow indeed. You would be better off setting up a raw data export, for example to Azure Blob storage: [Azure Blob integration | Piwik PRO help center](https://help.piwik.pro/support/integrations/azure-blob-integration/) You can then create a Power BI dataflow that queries those CSV files, and then set it to auto-refresh on a daily basis. You should have all the information you need in those CSV files (including ecommerce data), but you will need to spend a significant amount of time and effort to create the dataflow and the semantic model. With great power comes great responsibility… and complexity! 😅 ---
**Author:** ![anthonybartczak](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/anthonybartczak/32/2430_2.png) [@anthonybartczak](https://community.piwik.pro/u/anthonybartczak)\ **Post date:** [March 19, 2025, 6:44am UTC](https://community.piwik.pro/t/powerbi-connector-how-to-get-domain/4984/6 "2025-03-19T06:44:45Z")
We have made an update to the connector to include the domain transformation. Please let me know if you’d like me to send it to you in a PM or whether joao’s workaround works for you. @joao you mean a direct connector without the additional steps mentioned in this article right? > **[Microsoft Power BI service integration | Piwik PRO help center](https://help.piwik.pro/support/integrations/microsoft-power-bi-service-integration/)** > > Note: This integration is in beta and requires a Power BI Desktop account. We plan to release a built-in integration for Microsoft Power BI service soon. When you want to use data collected by Piwik PRO in Microsoft Power BI service, you need to use... In general, I’d like to return to the topic of rebuilding the Power BI connector. I can’t promise a big performance improvement, comparable to the Looker Studio connector, because we’re talking about different scopes here. Raw data will always be slower than the aggregated data available in the query API. ---
**Author:** ![Martin](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@Martin](https://community.piwik.pro/u/Martin)\ **Post date:** [March 19, 2025, 6:58am UTC](https://community.piwik.pro/t/powerbi-connector-how-to-get-domain/4984/7 "2025-03-19T06:58:47Z")
Good morning @anthonybartczak , yes please send me the connector in a PM. Does it also include product data for query API like you sent me last time? Thanks ---
**Author:** ![joao](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/joao/32/1820_2.png) [@joao](https://community.piwik.pro/u/joao)\ **Post date:** [March 19, 2025, 8:20am UTC](https://community.piwik.pro/t/powerbi-connector-how-to-get-domain/4984/8 "2025-03-19T08:20:20Z")
> [@anthonybartczak](#): > > @joao you mean a direct connector without the additional steps mentioned in this article right? @anthonybartczak Yes, I know you can set up an on-premises data gateway, but that is not really an option for most of the clients I work with: they don’t want to setup a dedicated computer just to run a marketing dashboard. Just imagine how cool Piwik PRO’s logo would look, sitting next to the big guns of Adobe Analytics and Google Analytics! 😉 ![power-query](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/8/81378071a9f3e5c58098958274056791644f06a1.png) ---
**Author:** ![anthonybartczak](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/anthonybartczak/32/2430_2.png) [@anthonybartczak](https://community.piwik.pro/u/anthonybartczak)\ **Post date:** [March 19, 2025, 11:36am UTC](https://community.piwik.pro/t/powerbi-connector-how-to-get-domain/4984/9 "2025-03-19T11:36:21Z")
Thanks for the feedback, I’ll send you an additional question related to this in a private message. ---
**Author:** ![system](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/db7013c4fd6a24443b339309db52f14995207737.png) [@system](https://community.piwik.pro/u/system)\ **Post date:** [April 2, 2025, 11:36am UTC](https://community.piwik.pro/t/powerbi-connector-how-to-get-domain/4984/10 "2025-04-02T11:36:58Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.