Forum Discussion

Clasteruga's avatar
Clasteruga
Frequent Visitor
6 years ago

Data flow Direct query mode

I created PBX file with Data flow data source (direct query mode), but this report don't work in Power bi services  
Need Help
Jewelski's avatar
Jewelski
Regular Visitor
6 years ago

Hi Clasteruga, have you been able to solve this issue by now?

 

I run into the same issue. I have enabled all the required settings, and I have the option to select Direct Query when getting data from a dataflow. Everything is working fine and I am able to publish to the Power BI Server. When I try to open the report in the Power BI Server I got the following error message:

Cannot load model

Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.

Please check the technical details for more information. If you contact support, please provide these details.

  • Underlying ErrorPowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: QueryUserError
  • QueryUserErrorUnable to convert an M query in table 'Test' into a native source query.

The datasource of the dataflow is Amazon Redshift. Is it true this isn't possible? Weird, since it works properly in the Power BI Desktop. If so, will this be available in the (hopefullyn near) future?