Source references other queries or steps, so it may not directly access a data source ISSUE

[Anonymous]

!!!!URGENT!!!!
For PowerBI Service when i upload my model and refresh it, it raises this error 
I know that this error can be fixed by ignoring Privacy level setting in power bi desktop and it works
But when moving to power bi service it fave this issue need a solution without the need to change the way i query data 

[Anonymous]

Hi @Anonymous ,

First of all thanks to GilbertQ  for the quick reply. Please allow me to add a few:

During my investigation I have found users in the past who have had similar experiences to you .
The solution given by other forum users was: 

1.You need to combine all the queries into one query.

2.Move the query to DataFlow and set it to ignore privacy settings.

For original post, you may refer to

Solved: Unable to Combine Data - Custom Function - Microsoft Fabric Community

Solved: Unable to combine data - revisited - Microsoft Fabric Community

Solved: .Unable to combine data - Microsoft Fabric Community

Hope it helps!

Best Regards,

Neeko Tang

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

[Anonymous · Accepted solution]

The solution was to get all data from the same source database (by creating the table in the different database as an external table in my original database)

[GilbertQ]

Hi @Anonymous 

Have you tried changing the privacy settings for your data sources in the Power BI Service?

[Anonymous]

Yes already did it 

I have tried all options and settings in Power bi service and desktop and yet didn't reach nothing