The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
i'm importing tables from devops in powerbi via odata. I'm not able to import workitems table; the error it gives me is the following:
every other table from the same connection is imported correctly. Does someone has any idea on how to solve this issue?
this is the m script:
"let
Source = OData.Feed("https://analytics.dev.azure.com/my_organization/_odata/v1.0/", null, [Implementation="2.0"]),
WorkItems_table = Source{[Name="WorkItems",Signature="table"]}[Data]
Solved! Go to Solution.
You may want to first try with a (much) smaller subset of columns.
You may want to first try with a (much) smaller subset of columns.
even if import only a signle column when i try to refresh preview in power query it gives me the same error
can you show the new code?
when i import this it shows me data but when i try to refresh it gives me the same error:
it worked selecting only the columns i was using for the report using a select directly in the url:
Source = OData.Feed("https://analytics.dev.azure.com/myorg/_odata/v1.0/WorkItems?$select=WorkItemId", null, [Implementation="2.0"])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
15 | |
12 | |
3 | |
2 | |
2 |