Forum Discussion

anilp's avatar
anilp
Helper I
8 years ago

Excel & Teradata Combined in Power BI Report refresh

Hi All,   We have a requirement ,   Data is coming from Teradata & Excel ( Excel data is added as Import Data from Web)   User created a report using both. The Data in Excel gets updated may be...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

anilp，

What web service do you store the Excel file in? And what authentication do you use to connect to Excel file in Power BI Desktop?

In your scenario, if you combine online data source and on-premises data source in a single dataset, you can use on-premises(personal mode) to refresh the dataset. What error message do you get when using the gateway? Do you install  the latest version of on-premises gateway(personal mode)?

Regards,
Lydia

anilp's avatar
anilp
Helper I
8 years ago

Anonymous,

 

My excel is stored on Sharepoint ,  Since its stored on Sharepoint I'm connecting it though Sharepoint Online list & 0Auth2 Authentication.

 

Lydia,

 

I installed the on premises gateway and tried to refresh but it's saying some authentication problem , even though my authentication is working on desktop. 

I raised a ticket to Microsoft and they mentioned there is some issue with the sharepoint refresh and they are in process of fixing it.

 

And they told me they will be installing new patch on Cloud next week ( hopefully it works)

 

Thanks,

Anil

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    anilp,

    If you still get error message when you set schedule refresh next week, please post the full error message.

    Regards,
    Lydia

    • anilp's avatar
      anilp
      Helper I
      8 years ago

      Still waiting for MSoft to provide update :), will update the post once I have update