Forum Discussion
We cannot convert the value "[Table]" to type Table error on merged query
I'm receiving the below error when trying to refresh a report on PowerBi Service. The error is coming from a query where I have merged an Excel table with a Azure Sql Database table. The report refre...
v-piga-msft
Resident Rockstar
Resident RockstarHi j_t0418,
Could you share the details error message? You could share the screenshots of the error message.
In addition, do you configure the Data Gateway and add data source in Power BI Service?
Besides, how do you connect Azure Sql Datebase, Import or Direct Query?
Best Regards,
Cherry
Hi Cherry,
Thanks for reaching out.
Everything is configured in the cloud and not via Data Gateway. Also, our Azure Sql Database is connected via Import.
Error message details are listed in initial post with the exception of the activity and request ids.
Thank You!