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 

Highlighted
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
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.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

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: 55 members 896 guests
Please welcome our newest community members: