Forum Discussion

SteveApa's avatar
SteveApa
Frequent Visitor
4 years ago

Source References other queries or steps, so it may not directly access a data

Refresh runs file from power bi, but when I try to refresh thru app.powerbi.com (Scheduled or immediate), the refresh fails: Source references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. 

1) I have set Privacy levels for all connections to None, 

2) I have File | Options | Privacy levels = Always ignore.

 

My querys.... 1st query get listing of project_numbers from 1 source (Denodo)

=== #"00) New - Project Listing - Denodo SQL" ===

let
Source = Odbc.Query("dsn=" & DENODO_32_OR_64, "
Select
p.project_number,
p.project_name,
p.project_current_phase_name,
p.project_governance_subtype_name
from
tep_projects as p
where 
p.project_number is not null
")
in
Source

 

====  #"10) Newest - PROJECT_NBR list - Done" =======

combine results of query above with...

= "(PROJECT_NBR = '" & Text.Combine(#"00) New - Project Listing - Denodo SQL"[project_number],"' OR PROJECT_NBR = '") & "')"

=======================

 

use above text combine in oracle query's where statement

===== 

let
Source = Odbc.Query("dsn=adw_adhoc", "
SELECT
PROJECT_NBR as ""project_number"",
TYCO_ELECTRONICS_CORP_PART_NBR ""material""
From
GBL_CURRENT.CORPORATE_PARTS
where " & #"10) Newest - PROJECT_NBR list - Done" & "
")
in
Source

 

  I use Text.Combine results of 1sq query and use this in the where sql statement on different datasouce (Oracle).  All works file in Power BI, but not on the published source scheduled refresh.

Thanks for the help!!

Harrisburg, PA

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi SteveApa ,

     

    Are there any screenshots of errors that failed to refresh?

    For now, you many check this link for troubuleshooting.

     

     

    Best Regards,

    Stephen Tao

     

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