Cannot view data for One report after publishing in workspace while i can view another report

[NOVICE02]

Weird scenario. I published a report on the department workspace and i get an error message" There is no gateway to access the data source" 

However, i know this is not an access issue because i have published another report (that i can still see) which has the same data source.

I am publishing to the same common workspace. What could be causing this ?

[v-yiruan-msft]

Hi @NOVICE02,

Whether your problem has been solved? If yes, could you please mark the helpful post as Answered? It will help others easily to find the solution when they get the same issue.

Best Regards

Rena

[v-yiruan-msft]

Hi @NOVICE02,

It seems that you are connecting to an on-premises data source , it required to configure the gateway. Fist, please navigate to the gateway list (click the gear icon in upper left corner of the page->Manage gateway ) and check if the corresponding data source has been added. You can refer this documentation to complete this step.

Then go to the dataset settings page(click the gear icon in upper left corner of the page->Settings--> Datasets tab) and check whether the gateway is toggle on and the related data source was included in dataset or not .

In additional, please check Power BI Desktop account which you used to publish that report, power BI Service account and gateway login account? Do they match? And check if you have any gateway instance registered with the gateway account you are currently logged into?

Best Regards

Rena

[amitchandak]

Refer:https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

[Greg_Deckler]

So I am assuming this is a Direct Query connection?

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".