Power BI error message

Answers

  • jon32
    jon32 ✭

    I am experiencing this and tried the fix. It did not work is there anything else to try for this error.

    'https://api.smartsheet.com/2.0/home' (500): Internal Server

    · Share on FacebookShare on Twitter
  • comadder
    comadder ✭✭
    edited 08/07/24

    I was following this to see if there was any update. Finally sent a ticket in to smartsheet. I got this back and it worked. Make sure the quotation marks around US below are straight, not slanted. This may only work if you're in the US. I believe for knew Power BI connections, use Smartsheet (beta).


    Migration Step (Power BI Desktop):


    Open the query editor by clicking “Transform Data” in the Power BI Desktop ribbon.
    In the “Query Settings” pane, under “APPLIED STEPS,” select “Source.”
    Edit the query by replacing Smartsheet.Tables() with SmartsheetGlobal.Contents("US") in the formula bar. Then, press Enter.
    Click “Edit Credentials” and log in with your Smartsheet account. (I didn't have to do this)
    Close the query editor window and click “Apply Changes.”
    Save the changes to your Power BI report.
    If the report is published, republish it to reflect the changes.

    · Share on FacebookShare on Twitter
  • comadder
    comadder ✭✭

    I was following this to see if there was any update. Finally sent a ticket in to smartsheet. I got this back and it worked. Make sure the quotation marks around US below are straight, not slanted. This may only work if you're in the US. I believe for knew Power BI connections, use Smartsheet (beta).


    Migration Step (Power BI Desktop):


    1. Open the query editor by clicking “Transform Data” in the Power BI Desktop ribbon.

    2. In the “Query Settings” pane, under “APPLIED STEPS,” select “Source.”

    3. Edit the query by replacing Smartsheet.Tables() with SmartsheetGlobal.Contents("US") in the formula bar. Then, press Enter.

    4. Click “Edit Credentials” and log in with your Smartsheet account. (I didn't have to do this)

    5. Close the query editor window and click “Apply Changes.”

    6. Save the changes to your Power BI report.

    7. If the report is published, republish it to reflect the changes.

    · Share on FacebookShare on Twitter

Categories