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,
I'm new to powerBI and have an existing dashboard using SharePoint/excel file as the data source. Is it possible to switch the source to use an OData connection instead? If yes, how is this done?
Thanks!
Create a second connection using ODATA. Make sure it produces exactly the same final result as your original query. Then in Advanced Editor copy the resulting M code and place it into the original query. Once everything works you can remove the new query again.
Lots of backups!!! This is not a simple process and can break not just power query, but also visuals, measures, groups, renamed columns etc etc.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |