cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mridul Helper III
Helper III

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.

18 REPLIES 18
Highlighted
mridul Helper III
Helper III

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.

 

 

mridul Helper III
Helper III

Not Able to SCHEDULE REFRESH my Organizational Content Pack

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-

 

 

Moderator v-qiuyu-msft
Moderator

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

Hi @mridul,

 

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/#tr....

 

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

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mridul Helper III
Helper III

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

@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

 

 

 

 Report Deployment.jpgError_Spark.png

Vicky_Song Impactful Individual
Impactful Individual

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

@mridul, I have to say that I can reproduce your issue, I will report it internally and will update here once I get any updates.

mridul Helper III
Helper III

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

@Vicky_Song I have already raised the TICKET. Microsoft Team is working on this Issue. Once i get this fixed done i will updated on the community. Thank you 

mridul Helper III
Helper III

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

@Vicky_Song

@v-qiuyu-msft

SCHEDULE REFRESH, Does NOT work even if you Upload your .pbix file to OnDrive Business, and try to Schedule.

It give the same Exact Error 

 

 

 

 

Vicky_Song Impactful Individual
Impactful Individual

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

@mridul, I got the information that there was a known issue with the ODBC driver support for Spark 1.6 connecting to Power BI and that they are already looking into it; however Spark 1.5 should be working properly. So, which version of Spark you're working with? 

mridul Helper III
Helper III

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

@Vicky_Song  Yes - its 1.6.0

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors