Forum Discussion

m_andel's avatar
m_andel
Helper I
10 months ago

Power BI Paginated Report with BigQuery DirectQuery – Filters not pushed down

Hi everyone, I’m currently facing the following scenario: My data resides in BigQuery, with potentially quite a large volume (up to ~13M rows). To simplify external queries, I’ve created a view in ...
Need Help
Tips and Tricks
m_andel's avatar
m_andel
Helper I
9 months ago

Hi, v-achippa 

I can now load data. My last issue is the connection to powerbi. Is it possible to use a google service account with a key file? I have found no option to configure the connection this way. 

v-achippa's avatar
v-achippa
Community Support
9 months ago

Hi m_andel,

 

Currently using a google service account key file is not supported in Power Query based connections within Power BI Report Builder or the Power BI Service. Only OAuth authentication with a user account is supported, so please use OAuth sign-in for now.

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Community Support
    9 months ago

    Hi @m_andel,

     

    As we haven’t heard back from you we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa

  • m_andel's avatar
    m_andel
    Helper I
    9 months ago

    Hi, v-achippa ,

    unfortunately there seems to be no solution to realize paginated reports the way we need to. Our next step would be to create such reports in Power BI Desktop. 

    As I understand there it is possible to query the BigQuery and use a service account for authentication. 

    And I suppose it is possible to design reports that feel just like paginated reports?

    Kind regards,

    Martin

  • v-achippa's avatar
    v-achippa
    Community Support
    8 months ago

    Hi m_andel,

     

    Yes power bi desktop can connect to BigQuery using a service account, so that part will work.

    However, power bi desktop is not a full replacement for Paginated Reports. You can create reports that look similar but desktop is designed for interactive visuals and does not support the same pixel perfect pagination, repeating groups and print ready layout capabilities that Paginated Reports provides.

     

    Thanks and regards,

    Anjan Kumar Chippa

  • m_andel's avatar
    m_andel
    Helper I
    8 months ago

    Hi, v-achippa ,

    thanks for the info. I will see how this fits for our purposes, in fact our reports are not meant for being printed out. Maybe i will miss the repeating groups. 

     

    Do you know, if authentication on BigQuery with service accounts in the Power BI report builder will be possible in the near future?

  • v-achippa's avatar
    v-achippa
    Community Support
    8 months ago

    Hi m_andel,

     

    Currently microsoft has not made any announcements about adding service-account authentication for BigQuery connections in Power BI Report Builder or Paginated Reports. The current Power Query connector only supports OAuth, and that’s the only officially documented method.

    If this is important for your scenario, I recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.

    Fabric Ideas - Microsoft Fabric Community

     

    Thanks and regards,

    Anjan Kumar Chippa