Forum Discussion

Bansi008's avatar
Bansi008
Helper III
1 year ago
Solved

Need help regarding Workspace refresh issue which merging 2 source tables.

Hi there – I have created one dashboard in which source of the data is SQL, but this SQL query is not hard coded. What I have done is, I have created an excel file with list of inscope accounts and u...
Need Help
  • Bansi008's avatar
    Bansi008
    1 year ago

    Anonymous - Hi I did some amendments in my SQL query and that is working as expected at my end

HarishKM's avatar
HarishKM
Super User
1 year ago

Bansi008 Hey,
Follow below step 

Solution: Go to File > Options and Settings > Options in Power BI Desktop (you can later publish to the Power BI Service). Then, under Global > Privacy, check the privacy level of the data sources involved (like SQL and others). Make sure that the privacy levels allow for data combination:

  • Private: Restricts combining data with other sources.

  • Public: Allows combining data freely.

  • Organizational: Allows combining data within the organization.

Ensure that the privacy level is set appropriately for all the data sources involved.

and 
Update your data source credential on Power bi service under report dataset setting - update data source credential.

 

 

Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query