Forum Discussion

Frequent Visitor

9 years ago

PowerBI Spark Direct Query Issue

Hi, I am facing a issue with Power BI, I am using Spark Cluster and plotting data using Direct Query. Issue is, I am able to plot data in Desktop Version, but the publish button is disabled and i...

tringuyenminh92

Icon for Memorable Member rank

Memorable Member

9 years ago

I don't know what is happening with your publish button, maybe some staffs will check it. for workaround solution, you could save your pbix file and go to PBI service, choose Get Data -> in Import or Connect to Data, choose Files -> Local File -> your pbix. Your pbix will be uploaded by this way when waiting some help from pbi team.

Girish
Frequent Visitor
9 years ago
HI,

I tried the solution mentioned but still ended up with the following error in Power BI Service.

Regards,
Girish
- Anonymous
  Not applicable
  9 years ago
  Hi Girish,
  
  When I connect to Spark cluster using DirectQuery mode in Power BI Desktop, I can reproduce your issue that Publish button is disabled. Once I upload the PBIX file to Power BI Service via Get Data ->Files->Local file entry, I also cannot view my report. You can check the following screenshots. I will report this issue internally and post back once I get any updates.
  
  However, when I switch from DirectQuery mode to Import mode in the current Power BI Desktop file, I can use publish button to upload the PBIX file to Power BI Service and the report displays with no issues in cloud. You can use this method as a temporary workaround.
  
  Thanks,
  Lydia Zhang
  - Girish
    Frequent Visitor
    9 years ago
    Hi Lydia,
    
    I cannot use Import in place of Direct Query as my data size is around 150 to 180 GB, this was the main reason behind using Spark Direct Query. If i change to Import i get the following error.
    
    Regards-
    Girish U R