Status:
Investigating
Direct Query not working with Dataverse and PBI dataset in Power BI Service
I have direct query data sources from dataverse and Power BI dataset and the report works fine in the PBI Desktop but gives error in the portal when the report is published.
v-cazheng-msft
Community Support
Community SupportHi JaideepS ,
Sorry for the delay. I found an similar error, this issue may be caused by the handshake process couldn’t be completed within 15 seconds between gateway and sql data source. If for some reason it cannot complete or it takes more than 15 seconds. Then you may get the error message as the follows:
There was an error when processing the data in the dataset.
May I know whether your SQL Server data source and your gateway are installed on different machines? Is your gateway the latest version? Could you please try to install the latest version of gateway on the data source machine and let me know the result? If it doesn’t work, I could provide other solutions for you. Thanks in advance!
Best Regards,
Community Support Team _ Caiyun