Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Apply button is greyed out when adding a data source to the on-premise data gateway

Submitted by Anonymous on ‎01-12-2023 10:32 PM

I noticed when I published a report with an on-premise data source (SAP BW) along with cloud data sources (Sharepoint), the Apply button is greyed out in the gateway connection settings:

benz_te_1-1673591313177.png

 

Again, this is only applicable to newly published datasets.

For the existing ones, there are no errors, and I can refresh successfully. Like this one, it has actually the same setup, just published in a different workspace some time ago:

benz_te_2-1673591452920.png


I just experienced this yesterday. 

Any of you are experiencing it now?

Appreciate the responses!

EDITED--

 

Check out the comments for the workaround

 

Microsoft has also posted the issue on the Power BI Support page. Expect the fix to be on 24th of January

benz_te_0-1674180041548.png

 

Status: Accepted
See more ideas labeled with:
21 Comments (21 New)
Comments
NickJ2011
Regular Visitor
‎01-16-2023 12:58 PM

Same issue here.  Is there an eta on when issue will be resolved.

Anonymous
Not applicable
‎01-16-2023 04:22 PM

@ntdanh Nice to know the workaround works to you as well! 

Nexter
Advocate III
Advocate III
‎01-17-2023 01:46 PM

@Anonymous Wow, can't believe that work-around worked, thanks!

SnejaMi
Regular Visitor
‎01-18-2023 07:57 AM

Hello,

We have the same issue. I hope it will be solved soon. 

Thanks in advance!

 

p.s. @benz_te thank you for the workaround!

Anonymous
Not applicable
‎01-18-2023 07:58 AM

Hello @Anonymous,

same issue here.

 

@Anonymous many thanks for the workaround. It works for me as well.

 

 

gazsam2
Frequent Visitor
‎01-18-2023 08:20 AM

I've got a second workaround...

 

1. Publish a new pbix file with the same name as the original to the workspace, and ensure that you have imported at least 1 table from each data source, however DO NOT include one from Sharepoint.

 

2. Map your data sources.

 

3. Replace again with the old pbix file...

 

this has worked for us here, where the mapping has stayed.

PBi_Analyst
Regular Visitor
‎01-19-2023 12:02 AM

There is also something wrong with Sharepoint Folder connector in Power BI Desktop. All reports using this connector in PBI platform is showing as Sharepoint List connector and it's not necognized as source in settings. BI Team please look at this also.

PBi_Analyst_0-1674115443983.png

 

 

ThomasElkem
Frequent Visitor
‎01-19-2023 12:25 AM

thanks @gazsam2 

your workaround works fine for us (and easier than to go to dev tool in the browser)

 

hope this issie will be fixed asap by Microsoft

Anonymous
Not applicable
‎01-19-2023 05:56 PM

@gazsam2 Good to know there's another workaround! More options the better

Microsoft has now posted the issue in the Power BI Support page: (just checked 20th of Jan, 2023 UTC)

benz_te_0-1674179745337.png

 

AzizB_FitBI
New Member
‎01-21-2023 01:22 PM

Having the same problem
microsoft ticket.JPG

Idea Statuses