Forum Discussion
Incomplete loading of data from BigQuery (DirectQuery) to Power BI
Good morning, how are you?
I have a table created from BigQuery that is updated daily and I analyze the data from it with Power BI.
The problem arises in the data sample, when I visualize the results on the dashboard with DirectQuery they are truncated or as if they were a sample and have missing information.
When I download the file directly from BigQuery, as a CSV and modify the data source to the file, it brings me the full data from the generated table on the dashboard.
Do you know if there is any limitation in the data load from BigQuery/PowerBI that does not sample ALL the data, or how to solve the problem?
Thank you very much in advance!
1 Reply
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi - otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
