Forum Discussion

mtcronin's avatar
mtcronin
Regular Visitor
2 years ago
Solved

Personal PowerBI no longer working

We have been leveraging PowerBI Personal Gateway for about a year now, and connecting to our on-prem MySQL Database.   It was working, but then we did a update to it per-requirements of the PowerBI G...
Need Help
  • mtcronin's avatar
    mtcronin
    2 years ago

    Good morning,

     

    Thanks to your guidance, I was able to resolve the issue. Here’s what I did:

     

    1. Create New Connections: I established all new connections under "Manage Connections and Gateways" because my previous ones were no longer functional. I added them using the Power BI Gateway (standard) as per your recommendation.
    2. Update Semantic Model Settings: I navigated to the Semantic model for the reports in question, clicked on "File," then "Settings."
    3. Configure Gateway and Cloud Connections: Under "Gateway and Cloud Connections," I selected the proper connections for each associated database from the drop-down menus, which I had created in step 1.
    4. Apply Changes: I clicked "Apply."
    5. Refresh and Update Schedule: Finally, I refreshed the reports and updated my refresh schedule.

    Thank you so much for your guidance; it was instrumental in pointing me in the right direction. Have a happy 4th of July!

     

    Best regards,


    Michael

mtcronin's avatar
mtcronin
Regular Visitor
2 years ago

From what I've read on PowerBI the PowerBI Gateway is an outbound gateway service and so since we don't block outbound traffic it has unrestricted ability to send data when requested, but you cannot access the data directly and never have been able to. 

Thats why the GW was put in place, and since we've not changed our FW rules from Amazon and it  WAS working previously and then stopped auto magically with no changes made to our Amazon Access Lists, I'm not sure what to focus on here.

Any advise?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

First time you mention Amazon. Should have led with that.

 

From what I've read on PowerBI the PowerBI Gateway is an outbound gateway service and so since we don't block outbound traffic it has unrestricted ability to send data when requested,

Mostly true except when your company employs proxies.

but you cannot access the data directly and never have been able to.

Please clarify what you mean here.

 

Can you confirm that your ODBC connections are set as System DNS ?

 

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

  • mtcronin's avatar
    mtcronin
    Regular Visitor
    2 years ago

    Good morning,

     

    Thanks to your guidance, I was able to resolve the issue. Here’s what I did:

     

    1. Create New Connections: I established all new connections under "Manage Connections and Gateways" because my previous ones were no longer functional. I added them using the Power BI Gateway (standard) as per your recommendation.
    2. Update Semantic Model Settings: I navigated to the Semantic model for the reports in question, clicked on "File," then "Settings."
    3. Configure Gateway and Cloud Connections: Under "Gateway and Cloud Connections," I selected the proper connections for each associated database from the drop-down menus, which I had created in step 1.
    4. Apply Changes: I clicked "Apply."
    5. Refresh and Update Schedule: Finally, I refreshed the reports and updated my refresh schedule.

    Thank you so much for your guidance; it was instrumental in pointing me in the right direction. Have a happy 4th of July!

     

    Best regards,


    Michael