Forum Discussion
ODBC.query with Excel cells parameters
Hi Guys !!! I'm new in this forum and quite new with power pivot and power BI. I've got one question that may seem easy for you guys. How do I link a Power BI parameter to an Excel cell ? Here ...
Hi Michael,
Ross's solution is also a wonderful way.
Regarding your issues, I had uploaded a demo. Can you download it? Maybe you can see the details if you have the file. The error message shows something related to the privacy level. I just ignored it. You can set them according to your needs. Please refer to the snapshot below.
Best Regards,
Dale
Hi Anonymous,
According to my test, we should load them as connections. Please download the demo in the attachment. Though it can't work in your side, you still can see the details.
let
Source = Odbc.Query("dsn=sqlserver", "select * from twoDates where startDate >= '" & Text.From(Table14) & "' and endDate < '" & Text.From(Table15) & "';")
in
Source
Best Regards,
Dale
I tried a lot of different google results but this '" & Text.From(Table14) & "' piece was what got me through my difficulty.