Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Refresh Content Pack from PBI Service : Reports create on HIVE Table

Hi All,

I have downloaded Data based on connection with - Azure HDInsight Spark (Beta) on PBI Desktop.
Below is the URL for the Driver i used and download HIVE Tables from SPARK cluster
https://www.microsoft.com/en-us/download/details.aspx?id=49883

I created a Report and Published to PBI Service.
I am NOT able to Reschedule Data Fresh : My PBI Service Account is a Pro Trail User account.

Error as below:
An error occurred while processing the data in the dataset.
Data source error: The import Spark.Tables matches no exports. Did you miss a module reference?
Also , in the Data Source Credentials it shows Blank , i mean there is NO field to enter Credentials.

Kindly suggest what went wrong . Thanks in advance.

Need Help
Tips and Tricks
Tutorial Requests

18 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi All,

     

    I have downloaded Data based on connection with - Azure HDInsight Spark (Beta) on PBI Desktop.

    Below is the URL for the Driver i used and download HIVE Tables from SPARK cluster

    https://www.microsoft.com/en-us/download/details.aspx?id=49883

     

    I created a Report and Published to PBI Service.

    I am NOT able to Reschedule Data Fresh : My PBI Service Account is a Pro Trail User account.

     

    Error as below: 

    An error occurred while processing the data in the dataset.

    Data source error:The import Spark.Tables matches no exports. Did you miss a module reference?

     Also , in the Data Source Credentials it shows Blank , i mean there is NO field to enter Credentials. 

     

    Kindly suggest what went wrong . Thanks in advance.

     

     

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    10 years ago

    Hi Anonymous,

     

    In your scenario, if you are getting data from Azure HDInsight Spark (Beta) on PBI Desktop, Power BI always has the most up-to-date data from your cluster so you do not need to schedule refreshes for the dataset. Please refer to this article: Visualize big data with Power BI and Spark on Azure HDInsigh.

     

    Besides, connection information from the Power BI Desktop is imported into the dataset along with the data. If you setup scheduled refresh or do a manual refresh on the dataset, Power BI will use the connection information from the dataset, along with a couple other settings, to connect directly to the database, query for updates, and load those updates into the dataset. 

     

    I guess there might be the issue on your data source. Please check if can allocate additional resources in the Resource Manager. Please see: https://powerbi.microsoft.com/en-us/documentation/powerbi-spark-on-hdinsight-with-direct-connect/#troubleshooting.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      v-qiuyu-msft Thanks for your Response. I changed the Resource Manager setting , still i see the same Error.

       

      I have attached 2 Screenshot :

      1) First is the Error which i see when trying to connect to Spark from Database option , in Power BI Service.

      2) Second, is the flow which i am trying to do. 

       

      Please refer to the Deployment handdrawn diagram for the Steps defined : 

      Step 1:- Successfully downloaded HIVE Tables on my PBI Desktop through Spark ODBC connectors

      Step 2:- Created Reports in Power BI Desktop, on my Local Machine

      Step 3:- Published Reports

      Step 4 :- Trying to connect to the Azure again through Service , so that Published reports should always be Updated as per the SCHEDULE REFRESH option in the DatasetOption 

       

      Kindly let me know where is the gap in my Deployment Diagram (Handdrawn)

      Secondly, What can be the probable issue for data NOT getting imported through Azure

       

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Hi All,

         

        I have published Organizational Content Pack. 

        While i am trying to RESCHEDULE REFRESH , i see following Error. 

         

        An error occurred while processing the data in the dataset.

        Data source error:The import Spark.Tables matches no exports. Did you miss a module reference?

         

        Please guide-