Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"])
User | Count |
---|---|
16 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
1 |