‘Gateway not configured’ in PBI Service when Static Data tables exist in the PBIX file

[FM_UNI]

When I upload certain Power BI PBIX files from PBI Desktop to my workspace, then there is an issue that the Gateway is ‘not configured correctly’ (screenshot 1). This makes no logical sense, as the same dashboards have worked for years

If I remove tables from the .pbix file which have static data (from ‘enter data’), and republish, then the gateway is working again (screenshot 2). However there are now mappings missing which affects the data

These tables are simple tables used for mapping which originally were entered with static data in ‘Enter Data’ button in desktop.

I also see the same effect with another .PBIX file which has a query for Refresh time, where code is used to read system date and then convert to a table

Let TodaysDate = DateTime.From(DateTimeZone.SwitchZone(DateTimeZone.FixedLocalNow(),0)),

 #"Converted to Table" = #table(1, {{TodaysDate}})…..

I have to remove this also to get the gateway to work.

Any idea why after publishing from Deskop, that we are no longer able to use the gateway in PBI Service? Gateways are all upgrades to May 2022 version

[FM_UNI · Accepted solution]

Update: seems to be a software issue. Was using old version of Desktop. I upgraded and now gateway mappings can be completed

[GilbertQ]

Thanks for letting us know.

[GilbertQ]

Hi @FM_UNI 

What I would do is to click on the option to create a new data source for the gateway where it is not working.

When it creates the new data source have a look at what the details are.

Then compare these details to the current working one. I am sure there might be some slight difference which is causing the issue?

[FM_UNI]

hi @GilbertQ 

the problem is when the power bi pbix file has a table entered manually in PBI desktop. These tables should not require any gateway mapping. 

If i remove the manual tables in desktop, then gateway works. If i add back a table using 'enter data' in PBI desktop and publish, then gateway no longer works.