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.
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
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.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |