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.
Hi All,
I have an Excel Lookup table linked to an SQL data import table linked to a Calendar table. The SQL data table and Calendar table work okay together but the excel Lookup and SQL data import table do not seem to.
I have exported the data from the SQL query into Excel and this Excel file works with the Excel Lookup table but I need the refreshable SQL table to work with the Excel Lookup table.
The data is the same, is there formating that needs to be done?
Regards
David
@DavidMU , what you mean by excel lookup. Can share the schema Diagram.
Can you share sample data and sample output in table format?
Thanks for getting back to me @amitchandak, the S&D table is a Lookup table, the MUe 2018 is an SQL data table and the third on the right is a Calendar table
SQL Data Table
Excel Lookup table
Is this what you mean?
Regards
David
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |