Data Gateway doesn't work its change to personal gateway

[chawalit]

Hi,

I ever used data gateway on my computer normally. But now I can not used it to connect to my SQL Server or my Files on my computer. The gateway its change to data gateway(Power BI - Personal). On my computer I had to install data gateway and Services already Start normally as below:

And on Gateway I already had and set it already as below:

And, when I connect to my Data Gateway its had to set to Personal Gateway and I can not change it to Data Gateway as below: 

But, The other dataset it still connect to Data Gateway as below:

I don't know why this dataset I can not use the Data gateway as the other dataset. Thanks for advanced for anyone can give me for the solution to solve this issue. 

Thanks

Chawalit

[Anonymous · Accepted solution]

Hi @chawalit,

Could you please post a screenshot of your data sources in Power BI Desktop? You can go to File -> Options and settings ->Data source settings to check data sources for Power BI Desktop.

Please note that when you combine different data sources in a dataset, you would need to add all the data sources under gateway. And for above Excel data source, please ensure that you use same paths to connect to Excel file in Power BI Service and Power BI Desktop.

Thanks,
Lydia Zhang

[chawalit]

Thanks Lydia Zhang, I had to remove my data source file to another location. And after set the file path location in Power BI desktop and re-publish to Power BI Services the Data Gateway can selected for my data gateway connection and everrying work fine.

Thanks.

Chawalit