Personal on premises gateway not working for new semantic models.

[ImPalaBI]

I have been working for years with a MySQL data base and Power BI. Both run on a server in EC2 from Amazon.

This is my workflow:

1. Open Power Bi Desktop
2. Get data from MySQL, using localhost and my user/pass
3. Create the report and publish to the service.
4. Edit semantic model setting, choosing the data gateway, and scheduling refreshes daily
5. Done, this has been working for years.

Now, I have to create new reports, and I follow the exact same workflow, but I get stuck after publishing:

1. Open Power Bi Desktop
2. Get data from MySQL, using localhost and my user/pass
3. Create the report and publish to the service.
4. Gateway not showing at all in the semantic model settings, can´t refresh data, life ruined.
   
   

Is not a connection or configuration error, because all old reports keep refreshing daily without a problem, only the new ones I want to create are getting these troubles.
I have updates both Power Bi desktop, and Personal on Premises Gateway.

Is there anything I´m doing wrong? How can I solve this? Many thanks in advance

Screen capture of and "old" dataset, showing my data gateway:

I copy and pasted the exact pbix file, published it, and the semantic model setting is not showing the on premises gateway

[v-xuxinyi-msft]

Hi @ImPalaBI 

Based on your description I ran the following tests:

In my testing, the data source is SQL Server.

"1 - Copy", It is a direct copy of the "1" PBIX.

"1-copy", It is opening desktop and creating a new report, reconnecting the data source.

My test results are as follows, I am not experiencing the same situation as you.

Are all your operations performed under the same account? Please feel free to let me know if my testing differs from yours.

Best Regards,
Yulia Xu

[aj1973]

Hi @ImPalaBI 

Try to update the Gateway to the latest version.

[ImPalaBI]

It is updated to the last version. But the problem remains.

[aj1973]

In your desktop you needed to connect the copied pbix file to the source before publishing it in order for the gateway to recognize the path.

[ImPalaBI]

I think you didnt even bother to read the post. The pibix file was connected.