Forum Discussion

rbrownson's avatar
rbrownson
Regular Visitor
9 years ago

Scheduled Refresh and Refresh Now giving Error

I scheduled a Refresh and it did not work. I tried to do a "Refresh Now" and it gave me the following error. My connections are connected and I am "online" with my data set. 

 

There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.

 

Data source errorColumn 'Order No' in Table '0018' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
Cluster URIWABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID637a9927-906e-472a-a572-7dcdd57b34d7
Request IDd63d4c31-77e0-e525-e5ec-4f5fcc7bca78
Time2017-06-09 14:10:45Z

 

Need Help

9 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    If this worked previously, this is generally an intermittent issue and will get resolved.

    • rbrownson's avatar
      rbrownson
      Regular Visitor
      9 years ago

      It has not worked at all. The data has not refreshed on my online version of the report nor the published report. I even try to manually do it and it does not refresh. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Download a copy of your PBIX file and test inside the "Edit Queries" section.  You might not be deleting those rows as well as you think.  This will also let you set up the Power Query to remove them for you, thus removing any requirement to do this manually.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    rbrownson,

    Are you able to refresh your reports in Power BI Desktop? Could you please check that if the ‘Order No’ column contains blank values in Query Editor of Power BI Desktop?

    Regards,
    Lydia

    • rbrownson's avatar
      rbrownson
      Regular Visitor
      9 years ago

      There are no blank rows as I remove all of them when I do my manual refresh. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Is the data source an Excel file?  I've noticed that blank rows at the end of the data file can creep in and cause this problem.  Best solution is to open it up in Power BI Desktop, and get the Edit Queries section to remove the rows that causing the blanks.

    • rbrownson's avatar
      rbrownson
      Regular Visitor
      9 years ago

      Yes one of the sources is in an Excel File. I refresh the data manually and delete all blank and duplicated rows. I save my Desktop report but it does not refresh the online report on powerbi nor the published report on the web. I keep getting the refresh error.