Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good afternoon everyone.
I'm new to Power BI and have been making good progress.
I've got a challenge that I've been struggling with for hours to solve and searching for answers hasn't gone so well.
In the Advanced Editor I have the following:
-- BEGIN
let
Source = Odbc.DataSource("dsn=EDW_64", [HierarchicalNavigation=true]),
EDWP_D2PM_Schema = Source{[Name="EDWP_D2PM",Kind="Schema"]}[Data],
SD_ITSM_PROBLEMS_VW_View = EDWP_D2PM_Schema{[Name="SD_ITSM_PROBLEMS_VW",Kind="View"]}[Data]
in
SD_ITSM_PROBLEMS_VW_View
-- END
What I want to do is import data from the table SD_ITSM_PROBLEMS_VW where DELETE_FLAG = 'C'
I don't know if it can be done. And if it can I haven't been able to figure out how.
I've tried to replace [DATA] with [QUERY=....] and that gave syntax errors on the =.
This query will be used through a gateway and thus also reduce the amount of data coming through. The reduced data will also mean that I will not need to add filters to every visualisation!
- David
Solved! Go to Solution.
Hi @dgwilson,
If I understand you correctly, you should be able to use the SQL statement option to import the ODBC data in your scenario.
SELECT * FROM SD_ITSM_PROBLEMS_VW WHERE DELETE_FLAG = 'C'
Regards
Hi @dgwilson,
If I understand you correctly, you should be able to use the SQL statement option to import the ODBC data in your scenario.
SELECT * FROM SD_ITSM_PROBLEMS_VW WHERE DELETE_FLAG = 'C'
Regards
This gives me an error.
Though based on this I think I may need to specify some additional parameters (like database name) before the table. I will experiment. Syntax may be a bit of guess work.
This seems to have solved it.
Note the <database name>.<table name> syntax.
Really appreciated your assistance and guidance. Thank you.
Hi @dgwilson,
Great to hear the problem got resolved! Could you accept your reply above as solution to close this thread?
Regards
User | Count |
---|---|
86 | |
83 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |