cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Irwest Helper II
Helper II

Published report from different sources doesn't work

I have a report with 3 different sources:

1. Excel file

2. PBI Calendar table

3. Tables from the DWH (SQL DB)

The report works at desktop, but when i pulish it and open from the service, i get the error:

"This data source cannot be accsessed by a data gateway..."

I've tryed to publish both: my workspace and group workspace.

 

Any ideas?

 

Thanks

12 REPLIES 12
Irwest Helper II
Helper II

Published report from different sources doesn't work

Hello,

I have a report with 3 different sources:

1. Excel file

2. PBI Calendar table 

3. Tables from the DWH (SQL DB)

The report works at desktop, but when i pulish it and open from the service, i get the error:

"This data source cannot be accsessed by a data gateway..."

I've tryed to publish both: my workspace and group workspace.

 

Any ideas?

 

Thanks

Super User IV
Super User IV

Re: Published report from different sources doesn't work

Are you sure that it's just not a warning? Seems that there is a new warning displayed when you publish a model that has sources that the Power BI Service feels that it cannot refresh. It is just a warning that the Power BI Service will not be able to automatically refresh your data.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Irwest Helper II
Helper II

Re: Published report from different sources doesn't work

Unfortunately, that's not a warning.

If i could attach the file, i'll show you the error.

The entire report doesn't show any tables, the only "X" or "cannot display the visual" errors

Super User IV
Super User IV

Re: Published report from different sources doesn't work

You should be able to upload a screen shot using Photos


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Irwest Helper II
Helper II

Re: Published report from different sources doesn't work

PBI error_Cannot display the visual.PNG

Super User IV
Super User IV

Re: Published report from different sources doesn't work

Oh, I take it that you are using a DirectQuery (Live) connection to your data warehouse? If that is the case then you will need to install a data gateway so that the Power BI Service can access the data in real time. Or, you could switch to Import mode and import the data from the data warehouse instead.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Irwest Helper II
Helper II

Re: Published report from different sources doesn't work

Thank you, Greg, for your answer, but i have already a defined gateway.

I'm not sure how it works when we have different sources. like excel table and DB tables, may be that's the reason?

I have other reports connecting to the exists gateway and it works excelent.

Super User IV
Super User IV

Re: Published report from different sources doesn't work

Right, there have been definite historical issues with having multiple different data sources where *I believe* this worked with a Personal Gateway but not an Enterprise Gateway. You may be running into this issue. Which type of gateway do you have installed, which mode?


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Irwest Helper II
Helper II

Re: Published report from different sources doesn't work

How i can find which type of Gateway do I have?

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

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

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.