Forum Discussion
Unable to load data in Data Marts (Timeout Error) (Bigquery) (CdsaMashupDatasourceUserException)
I'm getting the same error message when trying to load data from bigquery into the datamart. It has always been working fine, but none of the tables are now able to refresh, nor am i able to add new tables.
It does not matter if the table has a million rows, or just one (checked both), I still get the same error message.
3 Replies
refreshing the whole data mart works fine, but adding table/data (also in dataflows & datamart) gives the same error
Hi BRD_AMS ,
For the "Timeout was reached" error, you can refer to the following link:
Solved: Error interacting with REST API: Timeout was reach... - Microsoft Power BI Community
Solved: REST api to google big query crashes - Microsoft Power BI Community
ODBC:ERROR [HY000] [Microsoft][BigQuery] (8701) Er... - Microsoft Power BI Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have a similar issue (Data loading when using power BI desktop but unable to perform when publishing source as a dataset on cloud.) On my end its being caused when trying to load a table from a PostgreSQL database . (aprox 100MB in size ). Data loads on power query so everything is set up properly ,it only fails when publishing and saving changes.
