Forum Discussion

Alicia_Anderson's avatar
Alicia_Anderson
Icon for Resolver I rankResolver I
2 years ago
Solved

Unable to combine data - Power BI Service Refresh Error

  The report runs fine in Power BI Desktop but when I publish it to the service it errors.  I feel I have tried about everything but nothing works.     1) I made sure all my data sources privac...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Alicia_Anderson ，

     

    During my investigation I have found users in the past who have had similar experiences to you .
    The solution given by other forum users was: You need to combine all the queries into one query.

     

    For original post, you may refer to:Solved: Unable to Combine Data Refresh Error - Microsoft Fabric Community

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Alicia_Anderson 

This combination in the M code is not correct or not recognized in the service

 

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
2 years ago

aj1973 This is not true.

 

I tested this query in the Power BI Service and it works fine.

let
  Source = Csv.Document(Web.Contents("https://people.sc.fsu.edu/~jburkardt/data/csv/addresses.csv"))
in
  Source