PowerBI Connector how to get Domain

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.

Hi,

I have passed this issue to the dev team. This dimension might need an additional transformation. I’ll get back to you.

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:

@anthonybartczak Can we expect a Piwik PRO connector for Power BI Service any time soon? :folded_hands:

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

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

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! :sweat_smile:

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?

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.

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

@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! :wink:

Thanks for the feedback, I’ll send you an additional question related to this in a private message.