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
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