Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.