Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I got data from an excel workbook but the connections didnt import and when i try to import it from excel it says no queries found so now i cant refresh data.
I want to implement connections like this and query them with sql.
How can i add connections in power bi?
Solved! Go to Solution.
You can only load data from Excel that has been loaded to one of its worksheets.
But you can import directly from your SQL-server in Power BI instead.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
You can only load data from Excel that has been loaded to one of its worksheets.
But you can import directly from your SQL-server in Power BI instead.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |