Forum Discussion

albertoserinf's avatar
albertoserinf
Regular Visitor
8 years ago
Solved

Scheduled refresh failed : There was an error when processing the data in the dataset.

When trying to update dataset in Power BI service by using the scheduled data refresh via the gateway I got this error message       The pbix file has been created with Power BI Desktop...
Need Help
  • albertoserinf's avatar
    albertoserinf
    8 years ago

    Anonymous

     

    We solved this issue by creating a view of the table within the source database

    Thanks for your hints.

    Regards

     

    Alberto

Anonymous's avatar
Anonymous
Not applicable
8 years ago

albertoserinf,

You can write T-SQL to select required columns and rows from this specific table, then load data to Power BI Desktop.


Regards,
Lydia

albertoserinf's avatar
albertoserinf
Regular Visitor
8 years ago

Anonymous

 

We solved this issue by creating a view of the table within the source database

Thanks for your hints.

Regards

 

Alberto