Power BI throws 400: Bad request

API & integrations
1

Two days ago I was able to load Piwik PRO data to Power BI normally via connector. Today I’m trying the same, but I can’t choose any dimensions nor metrics.

When choosing site/Reports/Queries, there is only one required field (Start date) and then few optional fields (End date, Dimensions, Metrics, Dimension to transform 1, Transformation 1, Dimension to transform 2 and Transformation 2). I haven’t seen those four latter fields ever before. Dimensions and Metrics fields are just text fields, not drop-down menus like two days ago.

If I type Start date and click Apply and then trying to load data, I get 400: Bad request error.

What has happened?

power-bi-bad-request
power-bi-bad-request863×686 17.3 KB

2

Hey @Mika

I think this article might be helpful in your case:

Code 400 means there is bad request - either something is missing or setup wrong in request itself. Can you check if your query isn’t mixing some dimensions and metrics that shouldn’t be exported together?

Maybe it’s something simple, like start date in power bi doesn’t match timestamp because of format?

3

Hi jfidala,

The main problem is that I can’t choose any dimensions or metrics - those fields are just plain text fields, not drop-down menus like they used to be two days ago.

If I type something to Dimensions or Metrics fields, for example ‘Page URL’ to Dimensions field, it says ‘Enter a List value’.

Also, there are error messages in Raw data folders: ‘The field ‘column category’ of the record wasn’t found.’

As I said, two days ago all worked fine. I was able to just type start date and then choose dimensions and metrics from drop-down menus.

power-bi-bad-request2
power-bi-bad-request2854×509 27.5 KB

4

@Mika can you send me more setup details in PM? I can test it on power BI client and see if it works.

5

I just found a workaround to this problem: Using Get data → Blank query in Power BI, and then typing the needed script to Advanced Editor in Power Query Editor.

For example:

let
    Source = PiwikPROAnalytics.Contents("https://XXX.piwik.pro"),
    #"XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX" = Source{[Key="XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX"]}[Data],
    Reports = #"XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX"{[Key="Reports"]}[Data],
    Queries1 = Reports{[Key="Queries"]}[Data],
    #"Invoked FunctionQueries1" = Queries1(#date(2025, 1, 1), #date(2025, 3, 31), {"Page URL [event_url]", "Page title [event_title]"})
in
    #"Invoked FunctionQueries1"

That works fine even though the “Navigator”-way doesn’t.

1 Like
6

image
image536×317 24 KB

We’re also seeing the same thing this week, where no metrics are available to import into PowerBI either in reports or raw data. The workaround above is manageable if you are making a small amend to an existing model, but not if starting from scratch. Was there a solution or connector update?

1 Like
7

I got a message from Piwik PRO Support yesterday. They said they’re currently working on a fix for the connector.

1 Like
8

Thank you - good to know!

9

@Mika @mark-maxwell

We have updated connector to new version, it’s available under this article:

Let me know if it’s working okay now.