Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Gateways
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    7 years ago

    Hi Anonymous,

     

    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 

  • Anonymous's avatar
    Anonymous
    7 years ago

    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

michaelshparber's avatar
michaelshparber
Icon for Advocate V rankAdvocate V
7 years ago

Anonymous 

Thanks a lot Christin!

The problem is that I don't have a Gateway...(I don't need it since my data is from API)

I have talked to Microsoft Support and they tryied several things (delete dataset), publish to My workspace, and I also triple-checked my credentials

So somehow it is working now (I am still not sure what fixed it)

Thanks a lot!

Michael

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I have the same problem, I don't have a gateway but I already put the data sources as organizational, but in the same way it gives me this error

"Information is needed in order to combine data;Information about a data source is required.. The exception was raised by the IDbCommand interface. Table: NPIDataSource"

If I refresh the data in PB desktop it doesn't give me an error, but in PB web it does