Forum Discussion

Alberthoekstra's avatar
Alberthoekstra
Frequent Visitor
8 years ago
Solved

Update dataset problem data import report

Hello, I’ve got a report that is importing data from SQL tables. 2 tables that both have a date column and some value columns. So I’ve created a hard coded date table. And made a relationship t...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi Alberthoekstra,

     

    This is a known issue which was listed in Power BI support several weeks ago. By now, it has fixed.

     

    Please try again and if you still have this issue, please trace your gateway log and check if there is any error.

     

    Reference: 
    Tools for troubleshooting

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi Alberthoekstra,

 

It seems that you have problems when you refresh the dataset in Power BI Service?

 

What error do you have? If it is convenient, could you share the screenshots about your refresh error?

 

In additon, do you configure the Data Gateway in Power BI Service and add the SQL Server data source?

 

Currently, the latest Version of Power BI Desktop is : 2.61.5192.541 64-bit (August 2018). If you want to download the previous version of Power BI, you could download from here.

 

Best  Regards,

Cherry

Alberthoekstra's avatar
Alberthoekstra
Frequent Visitor
8 years ago

Hi,

 

Thanks for your response!

 

Yes, I've got problems when I refresh the dataset in Power BI Service (manual or automatic).

 

I don't get any error, just an incomplete dataset as result.

 

Yes, the Data Gateway is configured and the SQL Server data source is added.

 

Thank you for the link, I'll try the June version.

Someone suggested that that version should fix it.

 

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi Alberthoekstra,

     

    Have your fix the problem with the June version?

     

    If you have solved your problem, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If you still need help, please feel free to ask.

     

    Best  Regards,

    Cherry

    • Alberthoekstra's avatar
      Alberthoekstra
      Frequent Visitor
      8 years ago

      Hello,

       

      NO the problem is not fixed yet.

       

      Any suggestions?

       

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        8 years ago

        Hi Alberthoekstra,

         

        This is a known issue which was listed in Power BI support several weeks ago. By now, it has fixed.

         

        Please try again and if you still have this issue, please trace your gateway log and check if there is any error.

         

        Reference: 
        Tools for troubleshooting

         

        Best Regards,

        Cherry