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

Highlighted
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! 🙂

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.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 278 members 2,803 guests
Please welcome our newest community members: