Forum Discussion

Sreerams26's avatar
Sreerams26
Frequent Visitor
1 year ago

Gateway error - New to gateway concept

I have a Planning PowerBI dashboard created using desktop version and published to the planning workspace. I have created another dashboard called "Sales" by connecting to the semantic model of the p...
@gateway
@report server
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, Sreerams26 

First, you'll need to make sure that you have an on-premises data gateway installed. You'll need to sign in to the Power BI service and configure a gateway connection:

To set up a gateway connection for your semantic model:

 

 

Best Regards

Jianpeng Li

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

  • Sreerams26's avatar
    Sreerams26
    Frequent Visitor
    1 year ago

    Thanks for your reply but I already have a lot of gateway connection automatically created.  Further, in 2024, while I was creating dashboard by connecting multiple reports, I did not face this issue.  Why suddenly in 2025?  Further, with the steps defined, I am not able to fix these as I had already googled and tried them.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi, Sreerams26 

      Thank you very much for your reply.  You using a semantic model or a DirectQuery connection pattern to create reports.
      When we create a calculated table or calculated column under a table connected to Direct Query, we encounter this warning when publishing a report to Power BI Service:

      When our Power BI service does not have a corresponding gateway connection, after the publish is successful, the following will appear:

      You'll need to make sure that the semantic model you're using already has a gateway connection. Next, we need to configure the gateway connection for this report test333.pbix:

      Enter your credentials for the corresponding data source here:

      Click Create:

      It will then take you back to the settings page for the Semantic Model gateway connection, where you select the corresponding gateway connection and apply:

       

       

      Best Regards

      Jianpeng Li

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

       

       

       

       

       

       

  • Sreerams26's avatar
    Sreerams26
    Frequent Visitor
    1 year ago

    Thanks for the input.  Somehow I am not able to fix it.  I just deleted the source that was causing the issue and recreated differently.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi, Sreerams26 

      Thank you very much for your reply. Try creating one or more gateway connections based on the data sources your dashboard relies on (detailed steps in the previous reply) and then republishing from Power BI desktop to Power BI Service.
      Then go to Power BI Service and apply your gateway connection to the semantic model for the dashboard you just published.
      Please take a closer look at my previous steps, and if you encounter any problems during the configuration process, you can share some screenshots that include the issue and remove sensitive information. If you don't know if your current data source supports creating gateway connections, please tell me which data source you are using (SQL Server, MySQL, Oracle)

       

      Best Regards

      Jianpeng Li