Forum Discussion

Asmaa-elsheikh's avatar
Asmaa-elsheikh
Icon for Helper I rankHelper I
2 years ago
Solved

Google sheet connection with power bi

Hi All,

 

I am connecting my report to google sheet & suddenly the report does not call all the records in the google sheet, although I have checked that the data in the query  & it exists, but it's not reflected in the report; what I did?

 

Refreshed the PBI report in the PBI services

Refreshed the PBI report desktop

Refreshed the PBI report view in the query editor 

 

Note: this happedns after I swichted the work space capacity from Fabric Trial to Pro licence 

 

Still the data does not reflect in the report, how I could fix it ?

 

TIA

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Asmaa-elsheikh 

    Here are a few steps you can try to resolve this issue:

    1. Check Data Source Permissions: Ensure that the Google Sheets connector permissions are still valid after switching capacities. Sometimes, re-authentication may be needed.

    2. Inspect Query Settings: In the Power Query Editor, verify if any filters or transformations were inadvertently applied, causing some data not to be loaded.
      In such cases, I go through each step of Power Query one by one and check at which stage the rows disappear

    3. Clear Data Cache: Go to File > Options and Settings > Data Load in Power BI Desktop and clear the cache.

    4. Check Workspace Settings: Ensure that the Pro workspace settings are correctly configured to allow data refreshes from external sources like Google Sheets.

    5. Google Sheets API Limits: Check if there are any API limits being hit with the Google Sheets connection, which might cause incomplete data retrieval.

    6. Test in a New Report: As a last resort, create a new Power BI report and connect it to the same Google Sheet to see if the problem persists. This can help isolate whether the issue is with the report itself or the data connection.

      If this post helped, please consider Accepting it as the solution to help the other members find it more quickly

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    Hi Asmaa-elsheikh 

    Here are a few steps you can try to resolve this issue:

    1. Check Data Source Permissions: Ensure that the Google Sheets connector permissions are still valid after switching capacities. Sometimes, re-authentication may be needed.

    2. Inspect Query Settings: In the Power Query Editor, verify if any filters or transformations were inadvertently applied, causing some data not to be loaded.
      In such cases, I go through each step of Power Query one by one and check at which stage the rows disappear

    3. Clear Data Cache: Go to File > Options and Settings > Data Load in Power BI Desktop and clear the cache.

    4. Check Workspace Settings: Ensure that the Pro workspace settings are correctly configured to allow data refreshes from external sources like Google Sheets.

    5. Google Sheets API Limits: Check if there are any API limits being hit with the Google Sheets connection, which might cause incomplete data retrieval.

    6. Test in a New Report: As a last resort, create a new Power BI report and connect it to the same Google Sheet to see if the problem persists. This can help isolate whether the issue is with the report itself or the data connection.

      If this post helped, please consider Accepting it as the solution to help the other members find it more quickly