Dataflows DataSource Error

[Anonymous]

Hi all,

I'm testing DataFlows and have recently faced an issue while using Dataflows connector to get my dataset into Power BI Desktop.

My datasource is Azure SQL Data warehouse. While creating a dataflow everyting seems correct, data source tables are visualized in preview and I'm able to do transformations and save the dataflow.

Once I try to access it from Power BI Desktop, I get the following error:

Reason DataSource.Error

Message Missing partition information. Prease refresh the entity

Detail null

I've refreshed the entity but still get the error. Any ideas how this can be resolved?

[v-yuta-msft]

Hi maty,

Have you installed the lastest version? To use this Beta version of the power bi dataflows connector, you must be running the most recent version of power bi desktop. 

If you are using previous version, make sure you have downloaded a .MEZ file and place it in Documents > Power BI Desktop > Custom connectors folder. 

Reference: https://docs.microsoft.com/en-us/power-bi/desktop-connect-dataflows.

In addtion, if this error still occurs, there maybe something wrong with your report and Azure SQL data source, please check if you have changed some columns(add, delete columns, change data type).

Regards,

Jimmy Tao

[Anonymous · Accepted solution]

Hi, v-yuta-msft, thanks! The problem is resolved, I didn't take into consideration that the last step - refresh - can take a lot of time (~11 minutes in my case). So I was trying to import dataflow in the middle ofthis process and that was the reason of an error.  

[v-yuta-msft]

Hi maty,

Great to hear that, if you think my answer will be helpful to you, could you please kindly mark my answer as a solution?

Regards,

Jimmy Tao