Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |