Forum Discussion
Big Query refresh error in Power BI Service
Hi Xiaoxin,
I was able to fix it by removing the appended query step in Power BI and appending the data in Big Query before pulling it into Power BI.
Thank you,
M
Hi Anonymous,
Did you update your data structure on your data source side? Have you mixed both on-premise and online data sources in your report? Since we not so clear about your scenario, can you please share more detailed information?
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
No changes to data structure, and yes mixing on-premise and online data sources.
These are the query steps for the table in the error:
Source (Big Query Import) > Navigation > Renamed Columns > Appended Query (another query with same column names from excel).
Please let me know if you need more info.
Thank you,
M
Hi Anonymous,
Please create a duplicate query form the current query table and extract the parameter tables that used in the append query step to check if their data structure changes.
In addition, did this 'rename step' new added to your query table steps? If this is a case, you need to check below the original table query steps which used old field names and manually fix them with new column names.
Notice: Power query will cache the table structure into query steps, these structures do not auto-update.
Regards,Xiaoxin Sheng
Hi Xiaoxin,
I was able to fix it by removing the appended query step in Power BI and appending the data in Big Query before pulling it into Power BI.
Thank you,
M