cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jakuza Helper I
Helper I

Issues with Enterprise Gateway SQL Database

I've recently started setting up my reports to have a scheduled refresh. I have one report on Power BI that seems to be working fine with the refresh, but I just added a new report and I'm having issues with the refresh. It is connecting to my SCCM Database and I'm not sure if I'm missing privileges and permissions or something else is wrong. The option for enterprise gateway is greyed out even though I've added the dataset and made sure it matches the data source on the Power BI desktop file and the credentials are the same, also this is the SCCM template from PowerOn, not sure if that's important. Any help would be appreciated.

 

Thanks,

 

J

SCCM.PNG

 

3 REPLIES 3
Microsoft
Microsoft

Re: Issues with Enterprise Gateway SQL Database

I haven't worked with SCCM database before, but where does it reside?  You only need a gateway if the data source is on premises, so perhaps you don't even need the gateway?

Jakuza Helper I
Helper I

Re: Issues with Enterprise Gateway SQL Database

The Database is on premise. I have another report set up almost the exact same way and it seems to work. I'm not sure what I'm missing.

Microsoft
Microsoft

Re: Issues with Enterprise Gateway SQL Database

@Jakuza

Is SQL Server the only data source of the dataset? Based on my test, only when all data source are configured in the same gateway, the gateway can be used to refresh. If it is not your case, you can also try to remove the report and do a re-publish.

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors