Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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.

    ODBC-query-with-Excel-cells-parameters3

     

     

    Best Regards,
    Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous

thanks for your prompt reply. Not sure I understood your solution, sorry. I gave a little bit more of explanations to Dale, with an example of my current query, if it helps understand my issue.

 

thanks again

regards

Michael

Anonymous's avatar
Anonymous
Not applicable
7 years ago

What you need to do is extract a value from the table, rather than pass the table itself.  In the code that I provided, there is a specific line that says to get a value from a particular column and row.  See if you can use that code to get the value you need to pass in as your StartDate