Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Power BI Refresh Error

Hi, can someone help me with the error message below?

 

Data source error: Information is needed in order to combine data. Please specify a privacy level for each data source.;Information about a data source is required.. The exception was raised by the IDbCommand interface. Table: System One Actual.
Cluster URI: WABI-WEST-US-D-PRIMARY-redirect.analysis.windows.net
Activity ID: 824d1e1f-5191-4fc9-82ea-1efd6a637aaa
Request ID: 120f4549-acc6-7f13-8825-32cf5882a4e2
Time: 2025-02-15 02:08:06Z

 

System One Actual is dataflow which I created in one of my workspace. I have tried to attached "internal use" or "Public" or "Confidential - Internal Use" for the dataflow System One Actual, then tried refreshed my semantic model afterward. It still did not refresh successfully. 

 

 

Can someone give me some advice? Thanks,

Need Help

3 Replies

  • shafiz_p's avatar
    shafiz_p
    Super User
    1 year ago

    Hi Anonymous 

    You can follow my steps below:

    open the corresponding PBI desktop local file first and 

    Combine Data According to Privacy Levels:

    • In Power BI Desktop, go to File > Options and settings > Options.
    • Under Current File, select Privacy.
    • Ensure that the option Combine data according to your Privacy Level settings for each source is selected

     

     

    Check Privacy Levels:

    • Open Power BI Desktop.
    • Go to File > Options and settings > Data source settings.
    • Select your data source and click Edit Permissions.
    • Ensure that the privacy levels for all data sources are set correctly and consistently. You can choose between Public, Organizational, and Private

     

     

    Perform a desktop data refresh to ensure success. Ater the refresh is successful, you can republish to and try to reconfigure the data source definition for the data source of the related dataset to ensure that the "Privacy level" configured on the Serive is consistent with that of the Desktop:

     

     

    Check out the orginal solution here: https://community.fabric.microsoft.com/t5/Service/Data-source-error-Information-is-needed-in-order-to-combine-data/m-p/2753455 

     

     

    Hope this helps!!

    If this solved your problem, please accept it as a solution!!

     

    Best Regards,
    Shahariar Hafiz

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    No worries. I figured it out myself. Thanks for your help.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Anonymous 

       

      I'm sorry to bother you.

      Glad to know that you have solved the problem on your own. Would it be possible for you to share the solution? This will benefit other users who are experiencing the same problem.
      Thank you in advance for your time.

       

      Best Regards,
      Jarvis Tang
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.