cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lucas_ferronato Frequent Visitor
Frequent Visitor

Information is needed in order to combine data Table - without Gateway

Hi,

I've seen other posts with similar subject, but in my case I dont use gateway.


I've two data sources: 1_SharePoint and 2_AzureSQL.
I already looked at the privacy settings, both left in Public

I already did several tests and I can not figure out what is causing the error below:

 

Anotação 2019-06-17 105528.png

 

Power BI Desktop updates seamlessly. but when upgrading to PowerBI Web, gives the above error.

 

Please, any suggestion??

1 ACCEPTED SOLUTION

Accepted Solutions
lucas_ferronato Frequent Visitor
Frequent Visitor

Re: Information is needed in order to combine data Table - without Gateway

I even found the solution to my problem.

I discovered that when we set up a particular form of data source privacy on the PowerBI Desktop, when we publish it to the Service, (and there already was that connection) it does not update.

So I just needed to set up data sources again on PowerBI Web.

View solution in original post

5 REPLIES 5
lucas_ferronato Frequent Visitor
Frequent Visitor

Re: Information is needed in order to combine data Table - without Gateway

I even found the solution to my problem.

I discovered that when we set up a particular form of data source privacy on the PowerBI Desktop, when we publish it to the Service, (and there already was that connection) it does not update.

So I just needed to set up data sources again on PowerBI Web.

View solution in original post

CarreraBI Frequent Visitor
Frequent Visitor

Re: Information is needed in order to combine data Table - without Gateway

Thank you very much, I was searching this for days

NirvanaChan Frequent Visitor
Frequent Visitor

Re: Information is needed in order to combine data Table - without Gateway

Can you please elaborate on "set up the data source again" a little bit?

I have a Dataset that connects to a DF as its Data Source. The Dataset refreshes just fine in my Desktop client but fails on the service. I did delete the dataset and re-publish it on several occasions but it throws the same error over and over again.  
Here is how it is structured:
DB (privacy level organisation) + Azure app insights (privacy level none)
v
DataFlow (org)

Dataset (org)
v
Report 

lucas_ferronato Frequent Visitor
Frequent Visitor

Re: Information is needed in order to combine data Table - without Gateway

Hello NirvanaChan,

 

I mean, go to Settings on Power BI Web (https://app.powerbi.com/groups/ <<your ID >>/settings/datasets)

On Ribbon "Datasets";
Go to "Data Source Credentials" and "Edit Credentials"

Try it and tell us what go on! Smiley Happy

NirvanaChan Frequent Visitor
Frequent Visitor

Re: Information is needed in order to combine data Table - without Gateway

Hey Lucas, 

I did try that and sadly, that's not the whole fix but I did manage to get it to work. Here's what I did.

 

Changed the permission levels of the data sources for the dataset on the Desktop client.
Published it to the service with a different name.

Changed the dataset permission levels of the data sources for the dataset on the service again.

Performed a refresh.

This seems to have fixed my issue. Thanks a lot for your help. 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 115 members 1,802 guests
Please welcome our newest community members: