Forum Discussion
DirectQuery Dataverse not working in Power BI Service?
hello, I have a report with a contacts table that is updated by DirectQuery. Now I've published it to Power BI service it fails to load. Do I miss some steps?
Hi robinbeuk88 ，
The connection mode you are using is DirectQuery, in which case the visual needs to connect to the data source from the gateway in order to load the data if the data source is local.
Please install the on-premises data gateway and configure the gateway for the dataset.
Install an on-premises data gateway
Setting up Power BI Data Gateway
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
1 Reply
Hi robinbeuk88 ，
The connection mode you are using is DirectQuery, in which case the visual needs to connect to the data source from the gateway in order to load the data if the data source is local.
Please install the on-premises data gateway and configure the gateway for the dataset.
Install an on-premises data gateway
Setting up Power BI Data Gateway
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data