Error connecting Sharepoint (excel) file to PowerBI desktop file

%3CLINGO-SUB%20id%3D%22lingo-sub-1191883%22%20slang%3D%22en-US%22%3EError%20connecting%20Sharepoint%20(excel)%20file%20to%20PowerBI%20desktop%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1191883%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture3.PNG%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173182i0C35D0758B6D1E96%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20title%3D%22Capture3.PNG%22%20alt%3D%22Capture3.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture2.PNG%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173185i3E04A086D5B87AA0%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20title%3D%22Capture2.PNG%22%20alt%3D%22Capture2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHi%2C%20on%20Friday%20I%20connected%20this%20excel%20file%20in%20Sharepoint%20to%20a%20PowerBI%20desktop%20report%20I%20am%20developing.%20No%20errors.%20Today%2C%20Monday%2C%20as%20soon%20as%20I%20opened%20the%20PBI%20desktop%20file%2C%20I%20got%20the%20error%20(1st%20screenshot%20attached)%20which%20I%20didn't%20have%20on%20Friday%20and%20nothing%20has%20changed%20regarding%20file%20connections.%20Then%2C%20as%20a%20test%2C%20I%20opened%20a%20new%20blank%20Power%20BI%20desktop%20file%2C%20and%20tried%20to%20connect%20all%20over%20to%20the%20sharepoint%20file%20to%20see%20if%20I%20got%20the%20same%20error.%20And%20I%20sort%20of%20did%20-%20see%202nd%20screenshot%20attached.%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20what%20I%20don't%20understand%20is%20why%20there%20would%20be%20this%20error%20now%20when%20it%20wasn't%20an%20issue%20the%20last%20time%20I%20opened%20this%20file%20on%20Friday%20and%20nothing%20has%20changed%20in%20terms%20of%20connection.%20Thanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1191883%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edevelopment%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1417537%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20connecting%20Sharepoint%20(excel)%20file%20to%20PowerBI%20desktop%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1417537%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F567061%22%20target%3D%22_blank%22%3E%40aishayeoh%3C%2FA%3E%26nbsp%3B%3A%20Use%20the%20correct%20URL%20for%20the%20connection.%20You%20will%20get%20the%20URL%20from%20the%20Document%20properties%20which%20should%20always%20points%20to%20the%20document%20file.%20This%20is%20API%20URL%20for%20the%20Document%20which%20you%20can%20use%20to%20connect%20with%20PowerBI.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

 Capture3.PNGCapture2.PNG

Hi, on Friday I connected this excel file in Sharepoint to a PowerBI desktop report I am developing. No errors. Today, Monday, as soon as I opened the PBI desktop file, I got the error (1st screenshot attached) which I didn't have on Friday and nothing has changed regarding file connections. Then, as a test, I opened a new blank Power BI desktop file, and tried to connect all over to the sharepoint file to see if I got the same error. And I sort of did - see 2nd screenshot attached. 

But what I don't understand is why there would be this error now when it wasn't an issue the last time I opened this file on Friday and nothing has changed in terms of connection. Thanks. 

1 Reply

@aishayeoh : Use the correct URL for the connection. You will get the URL from the Document properties which should always points to the document file. This is API URL for the Document which you can use to connect with PowerBI.

www.000webhost.com