Forum Discussion

Katebrk's avatar
Katebrk
Helper I
5 years ago
Solved

Connecting data from BigQuery: empty tables

Hello!    I'm trying to connect data from Google BigQuery to Power BI Desktop through connector. The problem appears when I want to plug in data from GBQ to Power BI: Power BI says that the table I...
Need Help
  • Katebrk's avatar
    Katebrk
    5 years ago

    Hello!

    Thanks for the answer, I did this from the beginning and that didn't help. Also, that doesn't explain why I can't see the initial table from GBQ when connecting in Power BI Desktop. 

     

    I found the solution that helped me:

    1) after uploading the table in dataflows, I deleted some columns in the table (the columns that I don't need for my report in Power BI Desktop).

    2) then I copied the connection code from "advanced editor" in dataflow.

    3) put the code to Power BI Dekstop "advanced editor" and tried to connect to the table GBQ.

    4) when I did that, I got my table in Power BI Desktop. 

     

    So, I believe there are some restrictions or bugs with uploading data from BigQuery (maybe some restrictions on the size of data in the columns or something else), as Power BI doesn't see the initial table from Navigator pane, so I'm not able to upload it directly from connector, and I am not able to upload all the columns after using code from dataflows. 

Katebrk's avatar
Katebrk
Helper I
5 years ago

Hello!

Yes, I've refreshed the table, but the table in PBI is empty anyway. 

Neither I can see data in Power BI Desktop thought direct GBQ connector, neither through the created dataflow (however, dataflow sees the data from GBQ connector as I've decribed before, the table shows empty only when connecting this dataflow to PBI Desktop). 

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi Katebrk,

     

    After creating the new dataflow, please refresh the DataFlow on service to make data loaded into the entity.

    Then, click the "Refresh" button in "Navigator" pane.

    If still no data is shown, please clear permissions under "Data Source settings", and establish the connection to dataflow again.

     

    Best Regards,
    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

    • v-xulin-mstf's avatar
      v-xulin-mstf
      Community Support
      5 years ago

      Hi Katebrk

       

      Is your issue solved?

      If the issue has been solved, please adopt your solution to help others.

      😉

       

      Best Regards,
      Link

       

      If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

      • Katebrk's avatar
        Katebrk
        Helper I
        5 years ago

        Hello!

        Thanks for the answer, I did this from the beginning and that didn't help. Also, that doesn't explain why I can't see the initial table from GBQ when connecting in Power BI Desktop. 

         

        I found the solution that helped me:

        1) after uploading the table in dataflows, I deleted some columns in the table (the columns that I don't need for my report in Power BI Desktop).

        2) then I copied the connection code from "advanced editor" in dataflow.

        3) put the code to Power BI Dekstop "advanced editor" and tried to connect to the table GBQ.

        4) when I did that, I got my table in Power BI Desktop. 

         

        So, I believe there are some restrictions or bugs with uploading data from BigQuery (maybe some restrictions on the size of data in the columns or something else), as Power BI doesn't see the initial table from Navigator pane, so I'm not able to upload it directly from connector, and I am not able to upload all the columns after using code from dataflows.