I have created an instance on Google BigTable and created an external table on Google BigQuery and created an external table which can able to fetch records from BigTable. I tried to create a BigQuery datasource in Power BI Desktop but the external tables are not listing but the tables created on BigQuery are been listed! Is it an issue? or any possible solutions?
1
votes
This seems to be related to how Power BI is getting the table information. Was the table you created a permanent or temporal table? Did the issue persist after refreshing the data from Power BI?
- Tlaquetzal
Hi @Tlaquetzal i have created permanent table in bigquery which used to query data from the table in bigtable.Yes the issue persist even after refreshing the data.
- Balachander K
1 Answers
0
votes
I replicated your scenario and got the same behavior as the one you described. It seems that at the moment Power BI does not support BigTable external tables. A workaround is to create one or more views based on the BigTable table and then connect to those views.
In addition, if you're interested you can report the Power BI behavior here.
