Gateway error - New to gateway concept

[Sreerams26]

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 planning database and published to the Sales workspace. While publishing, I get the following messages.

"This semantic model contains calculated tables or calculated columns that refer to remote tables, which will result in refresh failure after publication if the dataset is not configured to use an explicit connection with granular access control to access this data source. Are you sure you want to continue publishing?"

I say yes and publish to the Sales workspace. The publish confirmation is as below

"Your file was published, but disconnected. Sales Dashboard is not connected to one or more data sources. To connect, go to dataset settings or ask the dataset owner."

As I am the dataset owner, give me step by step guide to fix this as this is the first instance I am getting this type of error  I am completely new to this gateway concept.  I browsed a lot and still unable to fix it.

Should somebody help, it would be great.

[Anonymous]

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]

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]

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

[Sreerams26]

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]

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.