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

Hi Anonymous try changing your code to:

 

#"Changed Type"{1}[Column1]

I don't think it will accept a zero.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi guys

it works now, you are awesome !!! It was this matter of privacy, I changed the settings, et voilà !

 

Anonymous,

0 works. As in many programming languages, first item in tabs is numbered 0. If I put 1, I've got an error saying I don't have enough elements in my table. But thanks for helping me, I appreciate !

 

v-jiascu-msft

thanks again for your patience and your clear-as-crystal explanations !!

 

regards !

Michael