Alteryx output connector

[Paullt]

Hello,

I have created a workflow in alteryx that generates for me a powerbi output dataset published in my workspace. When try to connect the data using powerbi desktop (get data-->powerbi semantic models) , i get the following error:

DirectQuery isnt available for this dataset.

Either this dataset doesnt support directquery, or you have selected a dataset stored in my workspace.

What is the solution? any hints?

[Paullt]

Thanks Sahir, thats what i will be doing!

[v-xianjtan-msft]

Hi @Paullt 

I'm just following up on this thread due to lack of response for a while.
May I ask if your problem has been resolved? If so please consider accepting useful replies as a solution that will benefit other users.
If you still have other problems, feel free to contact me.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sahir_Maharaj · Accepted solution]

Hello @Paullt

Instead of pushing data as a Power BI dataset, have Alteryx write data to a database that Power BI can connect to in DirectQuery mode:

1. Modify your Alteryx workflow to output the data to a database (e.g., SQL Server, Snowflake, or Dataverse).
2. In Power BI, use Get Data → SQL Server (or other DB source).
3. Select DirectQuery mode during import.

Hope this helps.