Forum Discussion

mohan_g_das1986's avatar
mohan_g_das1986
Icon for Helper III rankHelper III
6 years ago

Using Excel column as filter for SQL load into BI

Hi - I have to prepare a partner performance dashboard, The complete data is for 1000's of partners (in SQL table) what they buy, how many units & price other measures. The sales team will send me th...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi mohan_g_das1986 ,

 

I'm not clear either.  Do you use import mode to connect the Excel file and database? How do you use the partner id from Excel file to filter? And what do you mean use SQL dynamic filter to refresh the dashboard? Use a slicer or parameters?