search

specklesystems / speckle-powerbi

https://speckle.systems/tag/powerbi/
36 stars 15 forks source link

Fetch`DataChunks` into lists of objects or exclude them from the query #2

Closed AlanRynne closed 3 years ago

AlanRynne commented 3 years ago

PowerBI connector fetches the raw data from the Speckle server, but it comes with chunked lists, so it's not really very useful.

We must figure out a way to process that into the actual list of objects in PowerQuery M.

AlanRynne commented 3 years ago

After several chats with Claire we decided to park this for the time being.

Closing this issue, but should be reopened if/when the time comes.

teocomi commented 3 years ago

@AlanRynne @clairekuang can you please elaborate? Not being able to process chunked data makes this connector a bit useless, so we should def try to do that.

teocomi commented 3 years ago

Notes of the discussion today: https://www.notion.so/speckle/PowerBI-Hiding-DataChunks-056bd6c621eb4eadad0d5ee294cc232f

In short we will either try to exclude the DataChucks, since they only currently affect geometry or we will look into developing the plugin as a PowerBI Visual

clairekuang commented 3 years ago

In progress: code in place, needs debugging

These are not real blockers since users can manually omit these columns after fetch