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

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
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 

  • rscire's avatar
    rscire
    Regular Visitor
    7 years ago

    I was getting this error while trying to combine a Google Analytics (GA), BigQuery, SQL Server and Oracle datasource. Changing the datasources to "Organizational" solved the refresh problem in the PowerBi portal. 

  • RobertoBaggio's avatar
    RobertoBaggio
    Regular Visitor
    7 years ago

    @Qiuyun 

     

    I LOVE YOU! This answer solved my BI-life! Thanks!

  • chross's avatar
    chross
    Icon for Advocate III rankAdvocate III
    7 years ago

    This solution worked for me as well.

  • dwoolford's avatar
    dwoolford
    Frequent Visitor
    6 years ago

    Thanks Qiuyun you saved my day!!  🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you, I was having this problem for a last few days and this guidance helped resolved that issue, much appreciated.

  • akkitek's avatar
    akkitek
    Icon for Helper III rankHelper III
    5 years ago

    Hey v-qiuyu-msft,
    Thanks for this solution. I have an appended table which is being driven by 3 different tables with privacy levels set to none. I was getting this error and when I changed the privacy levels of these 3 tables to "Organizational". It worked fine. But I am just trying to understand as to why does this error occur?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    This solution didn't works for me, the error mssage persist: 

     

    I've tried all the privacy levels in desktop and online power bi but the error message continues. The Oracle connection is made through gateway. Is there any other solution that could solve the problem? 

    Thank you

  • Raritet_A's avatar
    Raritet_A
    New Member
    3 years ago

    Thank's! it really works