Zendesk connection - issues with the Calendar table

[Anonymous]

Hi everyone,

we connect to the Zendesk database using Power BI on the browser (we created a Workspace and we connect to the dataset from there). It all works great, except for the fact that after connecting to the dataset in PBI Desktop, the Calendar table isn't connected to any other table (other tables have normal relationships between them). As you can imagine, not being able to connect to the Calendar table is quite problematic. Is there any way I can edit the database relationships myself? Obviously I am unable to do so in Power BI Desktop, as we are using live connection. I also tried connecting directly through PBI Desktop (Get data -> Zendesk), but it was returning errors before I was able to really connect.

Thanks in advance 🙂

[amitchandak]

@Anonymous , does this mean a power bi dataset is already created without having a join with date table  and you are just using that.

In data model view, under property check do you have an option to change it to direct query.(once you clcik on table-> property pane ->advance)

Or try to add one more live connection, it might ask you to convert it into a direct query connection.

[Anonymous]

Hi @amitchandak,

Yes - the dataset was created without my organisation's involvement and the calendar table was never joined to any other table. 

Is this where I should look for this Change to Direct Query option? I can't edit the model, as I'm in the live connection mode.

As for your second suggestion - how can I do that? All options to get more data are greyed out.

Thanks 🙂