access data source file error

[rishan]

Hi,

i recently created a model taking data from 2 sources. One is a Powerbi dataset and the other is an excel sheet. i worked on the report using the desktop app and everything came out perfect. while publishing the same, no visual is displayed and a message pop up on top saying, there is no gateway to access the data source file.

Can someone please let me know what i must do? The ss of the error is displayed below. Thank you!

[v-kkf-msft · Accepted solution]

Hi @rishan ,

Is your Excel coming from local? If so, you will need a gateway to view the report that contains composite model.

• First download and install the standard gateway and log in using your Power BI Service account. For more information on gateways, please refer to https://docs.microsoft.com/power-bi/connect-data/service-gateway-onprem.
• Add a local Excel data source to the gateway.

    

• Edit the credentials of the shared dataset in the Data source credentials.

   

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@rishan Do you have a Data Gateway installed? https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install