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

Information is needed in order to combine data

 I am getting this error message when refreshing (manually or via schedule) on Power BI service. This happened initially on a complex data model but I narrowed it down to being and issue with combine queries.

 

I simulated another example with just 2 tables from 2 databases on the same SQL server. Both tables are appended. All works well on desktop but refresh fails on service.  

 

The gateway is installed and has always worked (and still works on other reports that do not use merging/appending queries). 

 

I have tried all combinations possible with the privacy settings with no success

 

From other recent posts I understand I am not the only one to have this issue. 

 

For info, I do not think that it is the merging itself that causes the problem. I tried with 2 Excel tables on a SharePoint site and that worked just fine. 

 

Christine

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Information is needed in order to combine data

Hi @ChristineW,

 

Please download the report and open it in Power BI desktop, go to Query Editor, refresh data to see if any message pops out. Also please go to the Data Source Settings, click on Edit Permission for these two data sources points to two databases, ensure both privacy level is Organizational. 

 

Then republish the report to Power BI service, go to Manage Gateways, ensure Privacy Level for these two SQL data sources is Organizational as well. Then refresh the dataset again. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ChristineW Frequent Visitor
Frequent Visitor

Re: Information is needed in order to combine data

Hi @v-qiuyu-msft,

 

Thank you so much, you solved my problem. The issue was at the Manage Gateways, the privacy level was "Private". I couldn't modify the existing datasource but could delete it and re-create it with the correct settings. 

Your help is really appreciated. 

 

Kind Regards,

Christine

12 REPLIES 12
Moderator v-qiuyu-msft
Moderator

Re: Information is needed in order to combine data

Hi @ChristineW,

 

Please go to Refresh History, click Show, there should be detail error information. Please share them with us. 

 

Also please share on-premises data gateway log files with us. You can upload it to your OneDrive and send the share link to me via private message. 

 

Please update gateway to the latest information then refresh dataset again to see if the issue still here. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ChristineW Frequent Visitor
Frequent Visitor

Re: Information is needed in order to combine data

REFRESH HISTORY information:

 

Type: On demand

Start: 29/11/2018 9:46:35 AM

End: 29/11/2018 9:46:40 AM

Status: Failed

Message: Cannot connect to the mashup data source. See error details for more information.

 

Underlying error code: -2147467259 Table: Append1.

Underlying error message: Information is needed in order to combine data

DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259

Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SQL","path":"MM-SQL02;<database1>"},{"kind":"SQL","path":"MM-SQL02;<database2>"}]

Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacySetting

Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net

Activity ID: 757d2275-8c38-4e46-9cdc-c2f52077ee00

Request ID: 0dde2f7b-d357-7f45-c38e-ff659f3cdb26

Time: 2018-11-28 20:46:40Z

 

 

ChristineW Frequent Visitor
Frequent Visitor

Re: Information is needed in order to combine data

The Logs have been sent to you via private message and the gateway updated to the November version. Data refresh still failed after the gateway update

Moderator v-qiuyu-msft
Moderator

Re: Information is needed in order to combine data

Hi @ChristineW,

 

Please download the report and open it in Power BI desktop, go to Query Editor, refresh data to see if any message pops out. Also please go to the Data Source Settings, click on Edit Permission for these two data sources points to two databases, ensure both privacy level is Organizational. 

 

Then republish the report to Power BI service, go to Manage Gateways, ensure Privacy Level for these two SQL data sources is Organizational as well. Then refresh the dataset again. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ChristineW Frequent Visitor
Frequent Visitor

Re: Information is needed in order to combine data

Hi @v-qiuyu-msft,

 

Thank you so much, you solved my problem. The issue was at the Manage Gateways, the privacy level was "Private". I couldn't modify the existing datasource but could delete it and re-create it with the correct settings. 

Your help is really appreciated. 

 

Kind Regards,

Christine

Moderator v-qiuyu-msft
Moderator

Re: Information is needed in order to combine data

Hi @ChristineW,

 

Good news. Smiley HappyAs the issue is resolved, I will close this thread. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
michaelshparber Regular Visitor
Regular Visitor

Re: Information is needed in order to combine data

@v-qiuyu-msft 

I have the same problem

I combine 3 queries from APIs and get the same error

Each query is running fine separately

I have Organizational Privacy level

and I have Ignore Security option checked

I don't have a Gateway since it's APIs from the cloud

Please help!

Thanks

Michael

Message:Information is needed in order to combine data Table: ACCOUNTS_UNION.
Cluster URI:WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID:47507ca3-341a-4619-96ce-23236dffc7a4
Request ID:af71938c-b45a-9845-5792-90cc300416b0
Time:2019-02-15 18:03:42Z
michaelshparber Regular Visitor
Regular Visitor

Re: Information is needed in order to combine data

I have spent 4 hours on this and I have narrowed the problem to one query

When I use it in Append - it causes the error

But the error is only in the service!!!!
Desktop is ok

There are no errors in the query itself and it loads OK by itself

DataSource is almost the same as the other two queries with just a slight difference in url

but the same Organizational Privacy and the same Basic authentication

Please help! @v-qiuyu-msft 

Thanks

Michael

ChristinW Visitor
Visitor

Re: Information is needed in order to combine data

Hi Michael,

So you publish to the online service, correct?

In my case the settings that were wrong were settings in the datasource on the online service. Desktop works well but when I published it to the service, it stopped working, generating the error message. 

 

For info, there are these settings within desktop (I think there are two) AND the setting on the Power BI online service that need to match each others. 

 

To fix it I :

  1. went to Power BI online,
  2. expanded the workspace with the faulty dashboard,
  3. in the section "Datasets" I clicked the ellipsis (3 dots) next to the dataset that had the issue,
  4. then option "Schedule Refresh".
  5. Expand the "Gateway connection" group
  6. click the "Actions" cogwheel (for info, there are other ways to get to the same point, this is just one).
  7. On the left hand side, open the Gateway cluster group and select the connection that has the issue. 
  8. There you will find the Authentication Method that seems to be the causing the trouble. As I said in my post, I could not alter an existing one to give it the appropriate settings, but it was easy enough to create a new one with the correct setting. 

As far as I remember, that was all that was required to fix it. 

 

All the best